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,