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.

[TomyLee]

@Admin,

I managed to make the code to run automatically at each change of cell B7, B2 and D2.
Once again thank you.