Copy Data into Multiple Worksheets from two Workbooks

[asugolflee2]

Hi Guys,

I am new to the thread, and I have a question.

I am trying to determine how to copy data from "workbook2" into "workbook1". "Workbook2" has in the first row of each column a name. I would like to match the first row of each column in "workbook2" to a worksheet who has the same name in "workbook1". For example: Cell B1 in "workbook2" may have the name John. I would like to match the name John within "workbook1" where there is a worksheet whose name is John. For "matching names" then I would like to copy cells B1:B20 into "workbook1" worksheet name "John."

I would like for this to continue through each column in "workbook2", matching names in "workbook1" with their corresponding worksheets and copying data in row 1 through row 20(each column in "workbook2" will have the same length) until there is no more names in row 1 for "workbook2".

Any assistance would be greatly appreciated!

 

[FDibbins]

Take a look at using the INDEX/MATCH function for this