Need part of formula within " " to become relative

Hello

I am very new to Excel but have managed to put together quite an extensive spreadsheet for work. I am just one formula away from helping to save myself days worth of work but would really appreciate some help with the final formula that I will need to copy and paste hundreds of times.

The formula that works perfectly is as follows:

=INDIRECT($B$3 & "!H9")

The part I am having problems with is making the H9 relative so that when I copy the formula to the right it becomes I9, J9, K9, etc and then when I copy and paste it down it needs to become H10, H11, H12, etc.

If there is no way to do this, I would literally have to manually edit this formula about 6,000 times...

Thank you so much for your help and I hope somebody can solve this for me! Once this spreadsheet is set up I will be able to use it for years - this is the last step I am stuck on.

Kind regards

Lawrence