ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   reference multiple tabs (https://www.excelbanter.com/excel-worksheet-functions/82772-reference-multiple-tabs.html)

Shitel

reference multiple tabs
 
I have about 150 tabs, each tab representing 1 product. Each tab contains
monthly volume. I want to create a master summary sheet that has the names
of all the products in one column and then pulls the monthly data from their
indivdual tabs. For eg:
Each product tab looks like:

A1234
Jan Feb Mar Apr May Jun.....

I would like the summary sheet to look like:
Jan Feb Mar Apr May Jun
A1234
A2345
A3456

Any help on how I can accomplish this, would be great!!
Thanks


All times are GMT +1. The time now is 11:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com