Can I use the following naming convention instead?

YTDTB01 reps mth 1
YTDTB02 reps mth 2

etc... since that is already what is in place?

thanks

"Curtis" wrote:

Where do I make reference in the formula to the source workbook say YTDTB (
note: the summary sheet resides in a different workbook than the source data)

Thanks

"Max" wrote:

Presume your 12 "month" source sheets are identically structured, with key
data in D7 across/down that you want extracted into your summary sheet. Take
a minute to rename the 12 "month" source sheets as the numbers: 1,2,3 ... 12

Then in your summary sheet,
the desired "month" will be input into C3, eg: 4 (for the 4th month)
In D7:
=IF($C$3="","",OFFSET(INDIRECT("'"&$C$3&"'!D7"),RO WS($1:1)-1,COLUMNS($A:A)-1))
Copy D7 across/down as far as required. Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Curtis" wrote:
I have a summary sheet that lists all divisions across the top (d7:q7)
It lists all GL accounts A3:A127
Also cell c3 is reserved for mth (numerically entered 1 thru 12)

My source workbook contains 12 sheets (each sheet representing a month)
-divisions are listed across the top (d7:q7)
-G/L accounts A3:A127
-costing d3:q127

Is than any formula that could look through all the sheets based on the
month number entered in cell c3 in the summary sheet. ( for example if 4 is
selected it would look for the worksheet representing the 4th month

Thanks