Search function across multiple work sheets

Hi all,

I have 6 worksheets with data. Column C of every worksheet is filled with unique Tracking Numbers.

I want to create a 7th worksheet with a search function. Users will be able to type in a Tracking Number (on cell A2), and information associated with that Tracking Number (from Columns A, D, E, F and G of worksheets 1-6) will show up beneath cell A2 on cells A4, B4, C4, D4, and E4.

Is this doable?

Any help will be greatly appreciated.

So I tried this:

=IF(ISNA(VLOOKUP(B6,'Chief Executive Office Group'!C1:G300,2,0)),IF(ISNA(VLOOKUP(B6,'Operations Group'!C1:G300,2,0)),VLOOKUP(B6,'Service Delivery Group'!C1:G300,2,0),VLOOKUP(B6,'Operations Group'!C1:G300,2,0)),VLOOKUP(B6,'Chief Executive Office Group'!C1:G300,2,0))

Which lets me look up across three worksheets.

I don't truly understand the If and ISNA functions and am not sure how to turn this formula to work for 6 worksheets instead of just 3.