Find Total Row on every sheet and make summary sheet

[Gman]

Is there a way to find "Total" in column H on every sheet, grab that entire row and put onto a summary sheet? the rows vary on every sheet that is why I cannot just say row 20 for example?

Thank you for the help

 

[Hui]

Is the Number of sheets fixed or does it change ?

Can you post a sample file?

 

[Gman]

Thanks for the reply Hui. The sheets are usually the same but additional can be added in the future.

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[Gman]

So awesome. Thank you Nebu!