Use Formula to Link to Data on Different Tab

[Enolt25]

I'm using the vlookup function to pull data on to a master summary slide. Currently my formula looks like this:

=VLOOKUP(A4,Brk!$A$3:$M$21,4,FALSE)

I'm looking to avoid having to the actually go to every dab and select the range. As all the tabs are identical (the data range is in the same spot on every tab) is it possible to create a column that contains all the tab names and link to the cell with the correct tab name in the formula allowing me to just drag the formula down on the summary tab. IE the formula would then look like this:

=VLOOKUP(A4,A5!$A$3:$M$21,4,FALSE)

*A5 = Brk

[bebo021999]

Maybe:
=VLOOKUP(A4,INDIRECT("'"&A5&"'!A3:M21"),4,0)