Summary Sheet contains sheet names and needs to pull data from worksheets listed

[benajamingeldart]

Hi everyone,

I have workbook1 which has column A populated with a list of the worksheets in workbook2. The list has blank cells between each value down column A. I now need to search through the workbook 1 column A list for "Strain Test Results" value in each of the worksheets listed in workbook2 then run the sub routine "Pull Data" then paste the data back into workbook1 column B next to the associated column A sheet name.

I don't wish to be explciit with the sheet names as these will change in the tool per project.

Thanks for your help.