I am new to Macros. I have to compile several monthly reports that combine
information from other reports into one or more spreadsheets. There are 7
department reports (originally crystal reports) that I have converted to
Excel. I want to copy and paste data from specific cells in the department
reports to the a separate spreadsheet for each department. One for each of
the 7 departments.

This is a simple copy/paste function. The macro I recorded to copy and
paste specific cell data to the new spreadsheet works well for set of data
where I recorded the macro. But when I try to run it on the report with data
from a different department, it copies the same information and data that was
on the first department report.

I have created a workbook as a template to run the macro and then just
copied different department data into the worksheet, but it still creates the
new spreadsheet with the 1st department data.

What am I doing wrong?