How To Copy Data By Worksheet Name

[TomyLee]

Hello Admin,

Thank you. Excellent. Code is excellent. Thank you very much.
How can I modify the code to be executed on every change in cell B7, B2 and D2.