Copy and Pasting unique characters using VBA

[Msears]

Hello All, you have been so hopeful in the past and I need to pick your brain on this. I have a workbook with 10 worksheets. They are labeled "1-10". I am wanting to copy Columns "A:H", beginning with Column A, row 2, since there are headers, and paste unique characters these into sheet11 "Clients", beginning with Column R, row 2. Also if possible, to clear the previous data pasted, and retrieve new data once sheet11 is activated? Thanks in advance, MS

 

[Msears]

I need to clarify my previous post. Please see below

I have a workbook with 10 worksheets. They are labeled "1-10". I am wanting to copy data in Columns "A:H", beginning with Column A, row 2, since there are headers, and paste unique values, not characters as previously mentioned, into sheet11 "Clients", beginning with Column R, row 2. Also if possible, to clear the previous data pasted, and retrieve new data once sheet11 is activated? Thanks in advance, MS