Scanning for common numbers through 3 sheets within a workbook

[slider.1978]

To all,
I have a variety of data on three different sheets representing machine 1-3 respectively.
The workbook has four sheets with sheet 4 being my main sheet.
Sheet 1 is renamed machine1.
it has part numbers, descriptions and quantities on columns A-C
Sheet 2 is renamed machine2.
it has part numbers, descriptions and quantities on columns A-C
Sheet 3 is renamed machine3.
it has part numbers, descriptions and quantities on columns A-C

What I am trying to do on sheet 4 is have my common part numbers on column 'A' (in order from lowest to highest)
As I am aware----- a common number is defined if it appears on all three sheets.

on column 2-- the corresponding description

on column 3 the qty for the corresponding sheet

If it appears on all three sheets then column 3 will represent qty for machine 1, column 4-5 for machine 2-3.

Any help would be appreciated.

[Jakobshavn]

First make a complete copy of the machine1 data in Sheet4
Then in Sheet4, cell D1 enter:

=ISNUMBER(MATCH(A1,machine2!A:A,0))+ISNUMBER(MATCH(A1,machine3!A:A,0)) and copy down

If column D shows a 2, then that row is on all the machine sheets.

First sort by column D and delete all rows that do not have 2 in column D.
Then sort by the part numbers.