Merging Sheets

[GirlToni_3475]

Is there a way to merge and sort similarities from 5 sheets to one sheet?

For example, i have 5 sheets with all the same column headings "part number" "description" "Machine" and "Drawing number" but some sheets have missing info, and some have more entered. im trying to combine all the information on 1 sheet without having to go line by line and make sure there are no duplicates or if there are duplicates make sure the correct information is filled in. trying to avoid having to go line by line on each sheet due to there being over 22730 rows on some sheets. Please Help!

[#2]

@GirlToni_3475 

copy all the data to one sheet in a new workbook, with one set of column headers at the top.  Select the entire range of copied data and choose Remove Duplicates from the Data menu.  This will scan through all rows and eliminate the duplicates.  Please note that 2 or more rows are duplicates ONLY if all data elements match EXACTLY.  You will still have to eyeball the remaining data to find rows missing data or rows that look like duplicates but have slightly different data - even something as minor as an extra space.