I have a HUGE spreadsheet, 212 tabs at the bottom.
I need to do a lookup to bring that data, from multiple cells, into a master
sheet.

My information is as follows:

1st tab:
Jan 1990

2nd tab:
Feb 1990

3rd tab:
Mar 1990

4th tab:
Apr 1990

Through current Month and Year.

Each tab/sheet is as follows:
cell A1 cell B1 cell C1 cell D1 cell E1 cell
3092323 hammer green 2 $14.34 pr


cell A1 cell B1 cell C1 cell D1 cell E1 cell

4456782 tape yellow 47 $3.71 ea

and so on, to fill 65,536 lines down by 31 lines across.(lots of information)

I want to bring the information, 8 of the 31 lines/cells across, from each
of the 212 tabs/sheets in this workbook and have them auto update the master
sheet information that is already put into a master sheet, as a count to the
appropriate cells, as follows:

cell A1 cell B1 cell C1 cell D1 cell E1 cell
4456782 tape yellow 47 $3.71 ea

cell A2 cell B2 cell C2 cell D2 cell E2 cell
4456782 tape yellow 47 $3.71 ea

cell A3 cell B3 cell C3 cell D3 cell E3 cell
4456782 tape yellow 47 $3.71 ea

and so on - basically I want to count, from each month tab and each year
tab, how many of each part went in each month and year, so I can build a
trend for inventory.
The cells in each page/tab; i.e. cell A1 on any given page is not the same
as any other page either. (that is due to some months that part was not used).
This is huge and I have no idea how to do it, so I do realize that this is
beyond what I know. Please help.

If you are simply looking to aggregate information from numerous other
sheets, a custom function will work. If you need to copy data, you'll need
VBA.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Champ" wrote:

I have a HUGE spreadsheet, 212 tabs at the bottom.
I need to do a lookup to bring that data, from multiple cells, into a master
sheet.

My information is as follows:

1st tab:
Jan 1990

2nd tab:
Feb 1990

3rd tab:
Mar 1990

4th tab:
Apr 1990

Through current Month and Year.

Each tab/sheet is as follows:
cell A1 cell B1 cell C1 cell D1 cell E1 cell
3092323 hammer green 2 $14.34 pr


cell A1 cell B1 cell C1 cell D1 cell E1 cell

4456782 tape yellow 47 $3.71 ea

and so on, to fill 65,536 lines down by 31 lines across.(lots of information)

I want to bring the information, 8 of the 31 lines/cells across, from each
of the 212 tabs/sheets in this workbook and have them auto update the master
sheet information that is already put into a master sheet, as a count to the
appropriate cells, as follows:

cell A1 cell B1 cell C1 cell D1 cell E1 cell
4456782 tape yellow 47 $3.71 ea

cell A2 cell B2 cell C2 cell D2 cell E2 cell
4456782 tape yellow 47 $3.71 ea

cell A3 cell B3 cell C3 cell D3 cell E3 cell
4456782 tape yellow 47 $3.71 ea

and so on - basically I want to count, from each month tab and each year
tab, how many of each part went in each month and year, so I can build a
trend for inventory.
The cells in each page/tab; i.e. cell A1 on any given page is not the same
as any other page either. (that is due to some months that part was not used).
This is huge and I have no idea how to do it, so I do realize that this is
beyond what I know. Please help.