I have a spreadsheet with a list of codes on separate tabs, each tab
is named according to its category .

On the last tab I have a list containing of ALL the above codes.

I want a formula to look at all of the tabs (apart from the final one)
and return the category for each code next to the relevant code in the
list on the last tab.

The end result is that each code in the complete list will have the
correct category next to it.

Any help appreciated.