I have two open worksheets. The VBA would copy data from the source
worksheet then paste that information to the target worksheet.

The exact target worksheet name is always in cell
c7 of the source worksheet. So, based on that value, it first locates the
same sheet number in the target Worksheet, then pastes the data.

The source worksheet (tab) name keeps changing and does not always match
precisely the name in cell c7 of that sheet (which does not change)
--
douglass