Vlookup Different workbook Cell refers to sheet

HI Guys,

I'm using vlookup to reference information from another workbook, but is it possible to adjust this code so the sheet is selected by Cell Reference.

Current Code

=VLOOKUP($B$5,'C:\Users\Admin\Documents\Work Docs\Reports\[Stats.xlsx]MTD'!$A$10:$AB$500,20,FALSE)

but would like the MTD to be changeable by cell value. for example:

C3 value could be one of - MTD, 0106, 0206, 0306

=VLOOKUP($B$5,'C:\Users\Admin\Documents\Work Docs\Reports\[Stats.xlsx]C3'!$A$10:$AB$500,20,FALSE)

Cheers for your help.