Index match multiple worksheets

Hello all,

Im new to this forum and am currently working on a formula that I'm having alot of trouble with.

In a nutshell, I am working on an generator that will generate cell item numbers (cell values) based on criteria. Since I have 12 different sheets beginning with week 1 - week 12, I'm basically trying to communicate to excel that if a number is listed on one of the 12 worksheets then tell me the date (another cell value)... then I will deduct todays date from the date it appeared for cycle count reasons. Basically, I already am aware that the countif function does not work with multiple worksheets, but I am looking for index match for different sheets within a workbook.

I know excel is limited with this, but any suggestions?

I could, but the workbook is set up so that another individual just has to print the worksheet after the numbers have been generated. Thats the only issue I have. The sheets are going to be generated by excel and printed. That why I need to keep the data seperate.

Thanks for the feedback