VBA to search all sheets of a closed workbook and return value

[Lee Francis]

Hi Guys,

I hope you can help

I have a list of reference numbers and I need to search these in a closed sheet and return corresponding data. It's just and INDEX & MATCH formula really but where I am falling down with this is that the data could be contained within any one of five sheets in a closed workbook!!!!

I only know how to reference individual sheets so I'm really struggling. Is there a way to search all worksheets and return data from a corresponding cell?

The data I am referencing is a delivery reference number and what I want to return is a comments field for each delivery reference number

Can anyone help with this? Any help would be very much appreciated

Thanks for taking the time to look at my issue

Thanks Guys

Lee.