I need to bring over from a workbook (8500BasicInfo.xls) details found in a
row 1 (A1:M1) and paste the cells onto a different workbook
(8500InputForm.xls) where the destination cells are scattered in different
locations throughout different Sheets. For example I need A1 from
8500BasicInfo.xls to be copied and pasted on to 8500InputForm.xls Sheet1 Cell
B3 and A2 copied and pasted onto Sheet2 Cell A1.
I then need to save the newly copied information as a new workbook. What i
am doing is creating documents with basic identifying information about the
case and then other users enter their findings on this document.

I will need to repeat this for every row (about 100 rows) in
8500BasicInfo.xls I will be repeating this every month as new cases come up.
so if any one here knows of a way to also save the file by assigning an
Automaticly created file name to it, for example their account number and
last name of the cells I have in the row I copied from.

Thank you