Sheet 1 has 7 Cells A1-A7 in those cells are numbers 1,2,3,4,5,6,7
Sheet 2 has 7 Cells A1-A7 in those cells are numbers 8,9,10,11,12,13,14
Sheet 3 has 7 Cells A1-A7 in those cells are numbers 2,3,4,5,11,12,13,15
I have a Query sheet that if I have a Cell say C4 and that if i type 3

i want it to say on C5 3 appears on Sheets 1 & Sheet 3 or a variation there of..

Make sence?

The sheet names are actually the 1st sundays of the week in mmm dd, yyyy format. this is a huge work book that will eventually contain 52 work sheets.