I would like some help creating a master sheet of rolled up information.

I have a workbook with 5 tabs with the following column headers: Part number, price, quantity with 220 rows. I would like to create a master sheet that would place all selected part numbers on the master sheet without blank rows from tabs 1-5 transferred on the main sheet. Currently I have to delete all empty rows to get it done to 20 to 25 rows which is normal size. This sheet has all totals on 1 page for printing.

Any help would be great.

gg