Command button to transfer multiple data to other sheets, saving in PDF, send email

Hi all,
I have attached the dummy sheet.
It is a bit complex ( for me) to achieve certain functions.
All is explained in the attached file.
Since I am learning, all seems too challenging for me or i am expecting too much. I dont know.
i have been on it for some time and can not find a solution.
I am very fortunate that so far I have been helped by many members and my words will fall short to thank them.
It may be bit similar to what I have been trying to achieve, however this is a different approach to it, hence a new thread now.
I am sure that there must be simple way of doing it.
( I can not figure out on how to attach tags.... basic though, but I will hopefully figure out in my next thread)

Please help me.

kind regards