Is there a macro I can create in order to copy or move data from one
spreadsheet to another?

We have data sheets showing our reps achievements. The data sheet has been
updated with new objectives and calculations. Some of the cells are locked
and protected. The locked cells are where they cannot be selected, so there
are blocks of cells only that require copying to the new data sheets.

Is there a way to automate this so we don't have to copy and paste the
information manually?

Any help will be greatly appreciated!

Thanks,
Cheri