Combining data from different workbooks

[kdolloff]

I recieve a data file on a monthly basis. Is there a way to take all of the monthly worksheets and combine into one workbook without doing a copy paste every month?

[Pepe Le Mokko]

Hi
you can use the add-in available here or one of the solutions from this page ( VBA code is included)