I have 10 workbooks that all contain info in the same format - these are sent to me from different locations around the country. The info is different, but again all in the same format - the one variable will be the number of rows containing info. One site may cave 400 records (rows) another 12, so on.



I want to combine all to one workbook.



Any way to do that without opening each one and doing a copy/paste?