Copy and paste values in WB2 to WB1 and do some actions to all worksheets in WB1

Hello All,
Hope you and your family doing well, safety is very important.
You really, really doing great job by helping us.
I am a beginner in VBA and I am an old member from India.
I have something to perform via Macro, Basically, I have two workbooks, WorkBook1 and WorkBook2, WorkBook1 is main which having other macros as well, right now doing the steps something manually, kind of copy and paste work. Now i wanted to perform all manual process in one click (macro button).
WorkBook1 is active WorkBook, the macro has to execute from here
steps:
1. once the button clicked in WorkBook1->config, it should copy the last available occupied cells from column c to column h from WorkBook2 -> sheet1
2. paste it to the WorkBook1 -> existing Sheet "Data" (enable clear contents, excluding headers before pasting) in Cell A2
3. Close WorkBook2
4. Then copy entire values in A column in "Data" Sheet in WorkBook1 and paste it into "Outlook Data tool" sheet in "A2" cell and remove duplicates, and run the existing macro in the WorkBook1 i have (the macro to fetch outlook details against email-id) and copy A and column B(exclude header), (so we need to call the macro here in this module)
5. Paste it to WorkBook1 -> "A2" cell in "Run" and "Sort names" sheets, and hide "Outlook Data tool" sheet
That's it.Please let me know if my requirement is not clear. Thanks