Copy paste print repeat between worksheets

[xBaelfire]

Hello everyone,

I have created work sheet where automatic email is created based on the values in the specific cells.

What I need now is to be able to copy paste values from cells B4 and L4 from work sheet1 into cells D8 and H8 in work sheet2. After this I want page from work sheet2 to be printed.
After printing macro should move on and take values from B5 and L4 (worksheet1) and paste in D8 and H8 worksheet2 and print. And so on so on.

Iwas trying to make it work but any time I try I run into the wall so after few hours I decided to ask you for help.

Thank you a lot in advance!

xBaelfire

 

[xBaelfire]

I was thinking maybe there is a way to create 2 buttons
1st button would copy data from sheet1 B4 and L4 int sheet2 D8 and H8. Then after every time I would press it the copied cells in sheet1 would automatically change to +1 which is B5 and L5.
so this way I could manually print this page by pressing second button which is "print" button and after pressing "change" button value would move on and i could print again and so on.