Substitue Sheet name with Indirect Formula

[Howardc1001]

I have sheet names in B2 onwards


I would like to amend the following formula by substituting the sheet name with the name in B2

Please Login or Register  to view this content.

Your assistance is most appreciated

[Keebellah]

Hi, lookup the use of INDIRECT() that's what you'd be wanting to use

[Howardc1001]

Hi Hans

I figured it out to be

Please Login or Register  to view this content.

[Keebellah]

Great! Sorry for just pointing you in that direction but seeing the number of posts you have I assumed you could find it and figure it out.