How do I use a vlookup equation on sheet 1 which contains a column with all
the tab names, eg 60093, 60094,....etc, to pull required data from the
respective tabs.

The equation i'm currently using is as follows
=VLOOKUP($D30,'60093'!$F:$AS,25,FALSE)

Any help would be much appreciated.
Thanks