Indirect/Vlookup? Dynamically choosing sheet within formula

[almorris100]

Hi all,

I currently have a spreadsheet with multiple sheets within it. Each sheet represents a work centre. Each sheet contains the dates that a number of tests have been completed. I currently have a separate audit spreadsheet that calculates the difference in dates between each consecutive column, but i have one of these for each centre i.e. with 12 centres, i have 12 separate audit sheets! I would like to change this to have 1 audit sheet that the formula can dynamically change which sheet it looks at by entering the sheet name in a cell or using a dropdown menu.

Unfortunately i can't share the exact sheet but i have attached an example of what i have currently.

Any help would be greatly appreciated.

 

[almorris100]

Sorry i can't find where to attach the workbook....