I have a tracking sheet for each sales person that I want to combine
together each week. Instead of copy and pasting over to one master because
this is very time consuming is there a formula or a macro that I can use
that will combine the data to one master sheet.

The sheet has 20 columns and depending on how many sales they do will be the
rows.

First 10 rows are just recap headings so I only want the data which starts
on row 11 amd column 4 to be copied over to a master.

Any help is a appreciated.

Thanks