1. I have an excel workbook containing multiple sheets (about 28-33) eg. Book1 and the worksheets are labelled eg. 01-March DS, 02-March NS, 02-March DS, 02-March NS ..... 31-March DS, 31-March NS in that order
2. Each of the sheets contains similar records or parameters but on different dates and shifts.
3. So, I need to find a function or macro which will do the following: if I enter a worksheet name in a new sheet (or new workbook) eg. Sheet (02- March DS) it will find/lookup across the whole workbook -Book1 (with all the sheets) and will give the reference for the respective cell as indicated in worksheet "02- March DS".