Help with creating a macro that will copy and paste data to multiple sheets.

Can you attach a sample file so we can see what may be causing the problem?

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Here you go mate. Thank you. I Was also wondering if its possible to get the data to paste below the titles in the columns you will see in each sheet rather thsn deleteling the columnsas it does now?

many thanks