Excel Formula pulling text from another cell

[RobMoore67]

cells 

a1 = apple

a2 = pear

=VLOOKUP($C8,'1. COM SERVICE'!$C$4:$J$25,6)

I need to make '1. COM SERVICE' variable.

VLOOKUP($C8,'a1'!$C$4:$J$25,6) so it would be VLOOKUP($C8,'apple'!$C$4:$J$25,6)

VLOOKUP($C8,'a2'!$C$4:$J$25,6) so it would be VLOOKUP($C8,'pear'!$C$4:$J$25,6)

Thanks for any help.

[#2 · Accepted solution]

@RobMoore67 

You may use INDIRECT, as variant

=VLOOKUP($C8,INDIRECT( "'" & A1 & "'!$C$4:$J$25" ),6)

[#3]

@Sergei Baklan 

Thank you so VERY much.

 It worked perfectly. 
Have. Wonderful day !

[#4]

@RobMoore67 , you are welcome