How do I get data from multiple workbooks to compile on a separate workbook. I have 12 monthly reports which have 3 worksheets each that I would like to consolidate into a yearly report. I would like to simply copy the whole sheet for January and then have February and the following months fill in, in the next available row. All sheets, books, etc have the same columns. Thanks
Bookmarks