Run Macros Between Workbooks & Combine Multiple Modules in one

Dear Team,

I need help with regards to macros, wherein I have done recording of actions which were being performed on regular basis between 2 excel workbooks named "Book" & "Bank". Recording consists of formatting of few columns and inserting couple of columns in both workbooks. Now user needs to perform vlookup in both workbooks with unique field in each workbook. Recorded macros are running smoothly however user has to run these macros in sequence in order to run them perfectly.

Now, my request is, is there any possible way wherein we can create one module and call all the macros one by one in a particular sequence affecting both the worksheets in one command. Thanks in advance for help.

Ataching Worksheets named : Bank, Book & BRS Macro (It consists of all the modules)
Sequence of Macros Should go as follows - 1. Book1, 2. Bank2, 3. BookVlookup3, 4. BookVlookup4, 5. Bookvlookup5, (You'll also find one module named MainMacro which I tried combining all macros, but it didn't work well, you can ignore this module)

Thanks in advance for help

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

Originally Posted by Pepe Le Mokko

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

Thank you