Index Match Across Tabs.xlsx

Hi All,

I was wondering if someone could help with a formula that searches across tabs. I have an excel sheet that I would like to use the index match function or some search & return function but be able to search across the excel sheets instead of writing an index match formula for each column.

Thank you very much in advance

Joseph