Trying to make excel combine column data across multiple sheets using a common identifier

Hi all,

I've used excel for a while but only using basic functions.

Ive come to a stage where I need assistance. Im even struggling to work out how to explain it.

Each row has data relating to a certain specified ItemNumber (in header) and has the same ItemNumber is in every sheet so Im trying to collate all the data which is specific to that ItemNumber into one sheet.

I hope this makes sense and have added an example sheet as an attachment

EDIT: So as Carim has done in the example he sent, I wanted Excel to look up find an "ItemNumber" which is apparent in every sheet and put the data to the right of it all onto one sheet with the ItemNumber on the first column and the rest of the cells from the other sheets in the same row from the same ItemNumber.