I am trying to create a simple copy/paste macro from one workbook with many
tabs to another with many tabs. The process is: a user opens an always
different named workbook runs macro from a menu. The macro then has the user
select the second workbook manually. The macro will then take data from the
second workbook and paste into first workbook.

How do I rename the first workbook only for the duration of the macro so the
macro knows to go back to that file to paste too? I hope this is clear.