I am a novice when it comes to macros...but I have to copy a bunch of
spreadsheets...both copying to the same workbook and copying to a new
workbook...I'd like to streamline the process and rather than copy/move,
etc., I wanted to either make a macro button or a shortcut key.  I can't
find anything on the web to help me.  I have to do this every week on
different sheets...so I'd like to have a macro that works for all the named
sheets.  Can this be done?
Thanks!
Lynn