Use INDEX and INDIRECT functions combined.

Hello,

I am trying to create a summary sheet with data from different worksheets. I'm using the INDEX function so I can drag the formula across columns in the summary sheet and get the data from specific cells in the worksheets. Since I will have several worksheets, I need help incorporating another function (perhaps INDIRECT) to be able to drag down the Summary Table for Sheet1 and get the the Summary Tables for the other worksheets.

I have attached an example of the file that includes the INDEX function I'm using. The red cells in the worksheets contain the data I need to populate the summary tables.

Any help will be greatly appreciated.

Thank you

Originally Posted by NBVC

You mean?

=INDEX(INDIRECT("'"&B4&"'!$N$30:$BZ$30"),1+(8*(COLUMNS($D$6:D6)-1)))

Thanks, that was exactly what I needed.