Combining data from worksheets based on matching information

Hi

I have a workbook with several worksheets. The first 3 columns of each worksheet contain the same information and serve as a unique identifier for each line of information.

I am trying to combine all of the information in each worksheet into a consolidated worksheet based on matching the information contained in the first 3 columns of each work sheet.

Is there a way that i can do this with pivot table or some code. I have attached a copy of the file that i am working with.

Any help would be appreciated.

Regards