VBA to Index/Match from Required Tab

[MrMaker]

Afternoon all,

I have the following:
4 x data tabs (all in the same format in columns A to M, with the lookup refs in A1:A30 (unique ID) and months in B1:M1
1 x summary tab

On the summary tab: From a dropdown in A1 I want to select the tab name (i.e "Sheet1"), and I then want the below cells on the summary tab to run a set of Index/Match formulas from the correct tab

Probably quite simple but I'm not very well up on VBA and the like

Thanks in advance

 

[James006]

Hello,

You are posting your current Index/Match formula ...

So in order to get a 'dynamic' sheet name ... you can take a look at the Indirect function ...

Hope this will help