I have a workbook that has multiple sheets. This workbook name changes
everyday. It has the date before the title, the date is the only thing that
changes. I want to create a macro that copies one sheet and pastes it to
another workbook. That part I can do. The next part is to go to the first
workbook (the one I am copying from) select another sheet and also copy that
to another sheet in the pasting workbook. The file name of the workbook I am
pasting it to is the same.