need help in creating a summary page

fim log.xlsx
I am just a basic user for excel and I have multiple work sheets that is formatted the same way and I would like to get the data on cells AK9:AO30 transferred to a summary page. Is there a way on doing this? Thanks.

Enter sheet name above table
and change formula (red field) to match that cell.

Formula:

Please Login or Register  to view this content.

It should work for every sheet.

So formula in H12 should be:

Formula:

Please Login or Register  to view this content.

Then extend it to the right and down to fill the table.

And so on for other tables.

thanks zbor. I'll try the given solution on my main work sheet. It looks like it will work.

If I wanted to have a printable summary page, does the positioning of the table affect the formula you gave me?

I tried the formula but it didn't come out right.. can you help me figure out what I did wrong?

FIM update LOG.xlsx

oops wrong file sent.

Your last file is empty: no formulae is SUMMARY so unable to determine problem.

Did you have tab name in B8? G8? not H!

=INDIRECT("'"&$J$9&"'!"&ADDRESS(11+ROWS($B$12:$B12),36+COLUMNS($B$12:B$12)))

Column numbers are changed when you copy: they need to remain as shown.