Forumla Help

[Travisallen2007]

I know this is probably something simple that I am just not thinking of but I'm struggling here and wanted to see if I could get some advise!

I have imported sales data into a spreadsheet over a large period of time, it has imported at one day per tab and has 133 tabs of unique data. I need to create a master sheet that says here are all the individual lines of data from all 133 tabs and here are the dollar amounts associated with them so i can then filter out what i need for that section of time.

The way all 133 tabs are set up are the same:
A1 Description
B1 Units
C1 Unit Retail
D1 Amount (B$*c$)

A2:D2 through the rest of the sales down the page are individual lines of data. This data may be the same Description as on other pages ex: Sold a USB drive 2.4am today also sold USB drive 2.4am tomorrow. If it auto combined these that fine, if it didn't auto combine them on the final page thats just fine too. There isn't a set amount of lines each page has and they are not in the same order on every page (didnt sell the same things every day).

Thanks again for any help!

 

[6StringJazzer]

First, the data design is working against you. It is much more difficult to compile data from multiple worksheets than it would be for you to use a single worksheet and import data at the end each time. How are you importing the data?

How are the tabs named? This might be solvable using a formula based on the INDIRECT function but the challenge is going to be the variable number of rows in each worksheet.

(Also a title that is a little more specific to your situation might attract more interest to your question.)