3 month Updating Sheet

[jsnelson]

Hello all,

I have a spreadsheet that has data on 12 sheets for each month of the year. What I am looking to do is make it pull the data from 3 months of the year, let's say April, May, June. I can do that with just summing the separate pages together but then the next month I would want to this sheet to automatically advance to the next month, so it would then be May, June, July. I always want to be looking at the latest 3 months.
Any tips on formulas would be helpful.

Thanks

 

[sheetspread]

Name the tabs 4-30,5-31,6-30, etc. Use an Indirect formula and the desired date to link the most recent months.

 

[jsnelson]

how can i show you my sheet and you show me an example formula?

Thanks,

 

[jsnelson]

A B

Name Open Orders
John Smith ='April 2011'!B3+'May 2011'!B3+'June 2011'!B3

 

[sheetspread]

Assuming the same format in each sheet (no change in names or order of names):

Excel Workbook
	A	B
1	Name	Open Orders
2	A	58
3	B	77
4	C	27
5	D	86
6	E	84
7	F	40
January

Excel Workbook
	A	B
1	Name	Open Orders
2	A	35
3	B	76
4	C	81
5	D	62
6	E	36
7	F	9
February

Excel Workbook
	A	B
1	Name	Open Orders
2	A	89
3	B	76
4	C	24
5	D	24
6	E	17
7	F	17
March

Excel Workbook
	A	B
1	Name	Open Orders
2	A	60
3	B	24
4	C	92
5	D	70
6	E	35
7	F	4
April

Excel Workbook
	A	B
1	Name	Open Orders
2	A	17
3	B	74
4	C	58
5	D	66
6	E	53
7	F	81
May

Excel Workbook
	A	B
1	Name	Open Orders
2	A	4
3	B	59
4	C	34
5	D	85
6	E	71
7	F	61
June

Set up the master with these formulas and month input:

Excel Workbook
	A	B	C
1	Name	Open Orders	6
2	A	81
3	B	157
4	C	184
5	D	221
6	E	159
7	F	146
Master

That's the most basic structure, with varying orders of names we'd include a vlookup

 

[jsnelson]

Wow! I think this will work perfect. Thank you very much!