Not done this myself, but it'd be along the lines of:

Set up a web server (e.g. apache) on the machine with apt mirror installed, make the apt mirror directory structure (/var/spool/apt-mirror) available through it and then add a repository through App Manager on your N900 (App manager titlebar menu > Application Catalogues > New) to point to your mirror.