basically, what i'm going to do is insert the filename into cell a1 on
sheet m as hc060313.xls, the first thing my macro will do is save the
file to the name in cella1, followed by extracting data from another
sheet and pasting it into different sheets on hc060313.xls (or
whatever that document is saved as that week) - the code included is
just part of the pasting process.

so i guess my question is, can i get the macro to activate a sheet
based on what the name is in cella1?
and secondly while i'm here, how would i go about forcing the file to
save as the name in cell a1?

thanks for your help :)