Formula to bring back cell accross multiple sheets

Hello fellow Excellers!

I have a workbook that contains 100 or so Invoices.
Each invoice is on a separate sheet and the name of that sheet is the invoice number eg INV1, INV2, INV3

I am trying to create a master sheet that contains the invoice total for each individual sheet - The total is located in cell H20 within each of the invoices

If for example in A1 down to A100 I have the name of the sheet (so A1= INV1, B1=INV2 all the way down to INV100) and I know that the total for each invoice is in H20 of each sheet, is there an easy way for me to write a formula using the sheet name located in column A ?

The manual way is to type ='INV1'!P20
I have tried typing =A1&"!"P20 but it doesn't seem to work

Hope this makes sense.......

Thanks All !!

Marcos

Try this
=INDIRECT(A1&"!P20")

Originally Posted by José Augusto

Try this
=INDIRECT(A1&"!P20")

You are a legend my friend.
Exactly what was required.

You have saved me a heap of time.. thanks again

Hi Marcos
Thank you for reputation.