Loop macro to grab all data (Row 15 down) from multiple tabs and paste in Reports tab

Hi All,

Hoping you can help with a data mining code for a spread sheet I have that holds many tabbed sheets, each that have a standard format that includes the first 15 rows as a header and row data from row 15 down to 200 max rows. Each row has data in columns from A to Y but rarely all 200 rows, often only 50. (ie total copy range could be as many as A15:Y200 but likely less)

I'm looking to create a reports sheet which:

A. Copy's values from each each sheet A15:Y200
B. Pastes values into Reports tab (Sheet 24)

I had a similar type of code that did this but only took singular cell values from each work sheet and made a list of them. In this case I'd like to do more in pasting all the values from row 15 and below so they're all in the same sheet. I attempted to edit it (as below) without luck, i'm not tied to that code style though!

Any advice? Thanks in advance!

Please Login or Register  to view this content.

I think this may help simplify it actually:

Pseudo Code:
For each sheet in workbook
Copy all rows with containing data from A15 into Reports tab

Try this one. It does not include copying headers, but can easily add to the code. The code excludes the following sheets from consolidation.

"Budget Summary" And "Remaining" And "Reports" Then

Please Login or Register  to view this content.