Formula to find the correct tab

i have got the following working great

=IF(HLOOKUP(C6,'M60 MSM Compliance'!$A$11:$AG$196, MATCH(B7,'M60 MSM Compliance'!$A$11:$A$153,0),0)="","",HLOOKUP(C6,'M60 MSM Compliance'!$A$11:$AG$153, MATCH(B7,'M60 MSM Compliance'!$A$11:$A$153,0),0))

I would like to develop this further now. So where i have got the link to tab 'M60 MSM Compliance'!, I would now like to change this to a formula and if Cell A1 = M60 MSM Compliance then that’s the tab i want it to go to and if A1 = a differnt tab name thats the tab it will go to.

I have tried a different ways but not managed to get it to work, is it even possible?

Any help much appreciated

Thanks, The below is coming up as volotile and REF#

=IF(HLOOKUP(C6,INDIRECT("'" & A1 & "'!$A$11:$AG$196"), MATCH(B7,INDIRECT("'" & A1 & "'!$A$11:$A$153"),0),0)="","",HLOOKUP(C6,INDIRECT("'" & A1 & "'!$A$11:$AG$196"), MATCH(B7,INDIRECT("'" & A1 & "'!$A$11:$A$153",0),0)))

Hello

This is the current formula im trying to use

=IF(HLOOKUP(C6,INDIRECT("'"&G5&"'!$A$11:$AG$196"),MATCH(B7,INDIRECT("'"&G5&"'!$A$11:$A$196"),0),0)="","",HLOOKUP(C6,INDIRECT("'"&G5&"'!$A$11:$AG$196"), MATCH(B7,INDIRECT("'"&G5&"'!$A$11:$A$196",0),0)))

I have attached the file as requested

o what i am trying to do is pull over specific data from the MSM tab over to the technical tab

Thanks JeteMc. Worked a treat