Hi

I have a workbook containing 100 worksheets. Cell E4 in each sheet (except the header sheet) contains its own reference, and the header sheet contains a list of those references. The worksheet names don't contain the reference, and can change.

What I want to do is use data validation in a cell on the header sheet to choose one of those references, and then move to the worksheet that contains that reference in cell E4. I've found some search tools, but can't work out how to exclude the header page from the search - as any search that I do returns the value in the list on the header page.

I can work in VB but only at a very basic level, any help you can give would be most appreciated!

Thanks, Robin