Thanks SirJB7 for the quick response. I will read and review the three first green sticky topics.
Clarification:
a) how many worksheets has each workbook? 4
b) if more than one, are there specific worksheet names to process? One specific worksheet name with a set range
c) in your master...
I am not an expert with macros. Here is my situation: I have 20 Excel 2007 Workbooks (All are the same) just different users. Each file is saved with the users first and last name. I need to create a macro in my master workbook that can copy each worksheet from each workbook to my master...