If same column in multiple sheets is marked with an X how can i extract surrounding data

[chrisjames25]

Hi, today i have what i think is quiote a challenge for you all but i could be wrong.

A while a go you guys helped me with a formula whereby if on one sheet i have column A titled "name" and column b titled "in stock" and i put an x next to each the the names in stock on a separate sheet these names would populate in list order. the formula was as follows:

=IFERROR(INDEX(Sheet1!$B$4:$B$73,SMALL(IF($A$11<>Sheet1!$C$4:$C$73,ROW(Sheet1!$C$4:$C$73)-ROW($C$4)+1),ROW(1:1))),"")

THis worked brilliantly but now i need to use this formula to search over multiple sheets. Is this possible or will i have to amend the forumula to reflect each sheet. THis would be a pain as eventually will have 52 weeks as sheets.

I have attached the spreadsheet as an example. Basically if column T has an x in it i want to populate all the data on that row into the sheet titled Opperman. As you will see I have done this using the above forumla for week 3 data and then realised what a pain it would be to amend the forumlas for the following weeks so wiondered if the forumla could be tweaked to check all sheets or speciifed sheets.

Apologies if not explained very well.