Copy specific data from multiple sheets to one

Hi,

I have a number of sheets for different clients.

Client1
Client2
Client3

The different client sheets contains different data, but columns A through L have the same headers in all sheets.

I would like to copy data from Client1, Client2 and Client3 columns A through L, and paste all of the data into MASTER sheet (Master sheet contains the same headers in column A trough L) without overwriting any data or removing dublicates

See attached example. Rows 3 & 4 in sheets Client1, Client2 & Client3 should amount to data in rows 3 to 8 in the MASTER sheet.

Thank you for your help.

/Andreas

Please Login or Register  to view this content.