macro which uses two worksheets at a time (copy and paste)

I am a novice in macros.
I only know how to record a macro and use 'relative referencing'

I have written the macro and I can reach a stage where it does the job and highlights the area (cannot get the formatting, but I can live with it).
I have attached the file.

I am getting stuck in copying the data to the adjacent sheet 'xxx'.

I would be grateful for your help.
Thank you,

Which data exactly are you wanting to copy and paste. It would be helpful if you outlined in steps what you want to accomplish.

Sorry.
In sheet 'copy', please select cell 'C8'. Then run my macro 'X'. Once you run my macro, you will see that it highlights the bunch of data.
I have to manually copy it and then paste it to the next worksheet 'xxx' (this time) from cell B74.
Then I go and delete all the rows (that I have copied) in sheet 'copy'.
Then start again from the next item, which now will be 'Product D'.

Thank you.

Again, please outline what you would like to do. e.g.

1. copy the contents of cell C8 in the "copy" sheet to cell "whatever" in "xxx" sheet etc...

with Macros you shouldn't need to select a cell and then run your macro. If you detail out exactly what you hope to happen we can probably come up with a solution that will work no matter who is using the file.

Sorry,

I ran out of time so could not reply to you.
FYI - I wanted to perform a 'relative reference' macro.

Thank you for your help.
I am not sure if I should tick this thread as solved.