Hi again,

I'm being working in a new excel project and I got to a point where my knowledge of excel does not allow me to go forward with the project.

I have a excel file where I have 1000 sheets where I introduce different invoices. Then I want to know how much I use for each article that I bought in different invoices during a certain period of time. I will make some tables in order to explain better what I want as well as the final result that I want to achieve.

sheet - F1
A B C D E
1 DATE: 15-09-2012
2 REF. DESCRIPTION QUANTITY UNIT PRICE TOTAL
3 qwe qwetest 50 32,00 1.600,00
4 asd asdtest 25 15,00 375,00
5 zxc zxctest 150 9,00 1.350,00
6 poi poitest 600 3,00 1.800,00
7 TOTAL: 825 5.125,00

sheet - F2
A B C D E
1 DATE: 08-10-2012
2 REF. DESCRIPTION QUANTITY UNIT PRICE TOTAL
3 qwe qwetest 45 28,00 1.260,00
4 asd asdtest 55 18,00 990,00
5 zxc zxctest 90 12,00 1.080,00
6 poi poitest 300 5,00 1.500,00
7 TOTAL: 490 4.830,00

sheet - F3
A B C D E
1 DATE: 02-11-2012
2 REF. DESCRIPTION QUANTITY UNIT PRICE TOTAL
3 qwe qwetest 20 25,00 500,00
4 asd asdtest 40 15,00 600,00
5 zxc zxctest 100 10,00 1.000,00
6 poi poitest 500 3,00 1.500,00
7 TOTAL: 660 3.600,00

sheet - F4
A B C D E
1 DATE: 15-10-2012
2 REF. DESCRIPTION QUANTITY UNIT PRICE TOTAL
3 qwe qwetest 70 22,00 1.540,00
4 asd asdtest 35 13,00 455,00
5 zxc zxctest 120 8,00 960,00
6 poi poitest 700 3,00 2.100,00
7 TOTAL: 925 5.055,00

After having a list with 1000 sheets I need to make them to combine the results into a summary sheet. On the summary sheet I want to limit the date period that I want to see how much I bought from each product type.

So I need a formula which picks me the quantity for a specific product reference in between a date interval.
I can do the formulas sheet by sheet but to make it easier and faster I would like to have a formula which makes all the steps in one.

sheet - Summary
A B C D E
1 FROM: 01-10-2012 TO: 30-10-2012
2 REF. DESCRIPTION QUANTITY AVERAGE PRICE TOTAL
3 qwe qwetest 115 24,348 2.800,00
4 asd asdtest 90 16,056 1.445,00
5 zxc zxctest 210 9,714 2.040,00
6 poi poitest 1.000 3,600 3.600,00
7 TOTAL: 1.415 6,986 9.885,00

The cells which are highlighted with blue are the ones that I don't know how to make them. I need a formula that searches in all the 1.000 sheets and summarizes in this sheet.

I hope that someone can help me with this. I have a solution but the file is with 45 MB and is very slow to work on it. I made trough a couple of tables to achieve my final result. It works but it takes to long to open, to save, to work.

That's why I'm looking for a faster alternative without using macros, which is another thing that I don't know how to do it.