Hello,
I have multiple tabs named whatever you like.
I am needing to compile this data from multiple sheets (tabs) in the same workbook onto its own sheet (tab) inside the same workbook.
The data below is an example of the data on each tab and may have blank rows and there is no limit on the number of rows the data may be found in.
The data will be in the exact same columns on each tab and have the exact same headers on the first row of each tab.
You can use whatever headers or columns you want for your example.
Active tabs come and go and i need a way to have a list of tab names that the formula looks at to determine what tabs it will pull in data from.
The formula should only pull in data from the tab names in this list but other tabs will exist in the workbook.
I will change this list of tab names as needed manually and there is no limit to how many tab names can be in the list.
The result would be on its own sheet (tab) and look just like below but without the empty rows.
Thank you!
I have multiple tabs named whatever you like.
I am needing to compile this data from multiple sheets (tabs) in the same workbook onto its own sheet (tab) inside the same workbook.
The data below is an example of the data on each tab and may have blank rows and there is no limit on the number of rows the data may be found in.
The data will be in the exact same columns on each tab and have the exact same headers on the first row of each tab.
You can use whatever headers or columns you want for your example.
Active tabs come and go and i need a way to have a list of tab names that the formula looks at to determine what tabs it will pull in data from.
The formula should only pull in data from the tab names in this list but other tabs will exist in the workbook.
I will change this list of tab names as needed manually and there is no limit to how many tab names can be in the list.
The result would be on its own sheet (tab) and look just like below but without the empty rows.
Thank you!
| BLDG 1 | BLDG1 DRAFT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| BLDG 1 | BLDG1 STAIR | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| BLDG 1 | BLDG1 SHEAR | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| BLDG 1 | BLDG1 EXTRA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| LEASING | LEASING | 80 | 250 | 9 | 16164 | $3,717.72 | Jhonny Grabiel Fuentes | |||||||||
| LEASING | LEASERC | 300 | 0 | $300.00 | Jhonny Grabiel Fuentes | |||||||||||
| LEASING | LEASEDRAFT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| LEASING | LEASESTAIR | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| LEASING | LEASESHEAR | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| LEASING | LEASEEXTRA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez | ||
| FITNESS | FITDRAFT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 1988 | $298.20 | Jose Gonzalez |
