I'm trying to copy specific worksheets into one called Summary that I have already created (worksheets are Bathroom, Plumbing, Tiling, Plastering, Labour-Sundries). I need it to only copy the rows that have a 1 in column A from each sheet, and not copy the header row. I would also like it to copy the formatting and I would like it to start from row 10 in the Summary sheet so that I can put calculations in at the top.

Please can someone help I've been trying different examples that I've adapted for hours with no success! Thank you