Extracting data from multiple worksheets

[marcus]

Hello,

I have searched the forum and have not not found an answer to my question, perhaps someone here can assist.

I am analyzing past monthly income statements (IS) and would like to extract certain values from all of the worksheets and put them in a summary worksheet.

Each IS is on its own tab. Each IS follows the same format. There are more than 60 with more added each month. The attached sample file is similar to what I am working with.

The summary worksheet has a list of all worksheets (formatted as "YYYY MM") and the data that I want to extract from the corresponding monthly IS (rows 1 and 2).

Any thoughts?

Thank you,

Marcus

 

[Deepak]

Hi,


Put any of the below in B3 & drag right/below.

=INDIRECT(ADDRESS(ROW(INDIRECT(B$2)),COLUMN(INDIRECT(B$2)),1,1,$A3))

=INDEX(INDIRECT("'"&$A3&"'!$B$3:$B$7"),MATCH(B$1,INDIRECT("'"&$A3&"'!A$3:$A$7"),0))

 

[marcus]

Deepak,

Thanks for the quick reply. The 'Address' function was key and the one I was looking for.

Marcus