Hello,
I can certainly combine these worksheets into one. I will use Excel functions and/or VBA code, if this will make things faster and more efficient. I have done a similar merge before, with fewer spreadsheets coming from Zoho crm. I will need max 2 days. I could also write VBA code for the merge, which could be used in the future, given that spreadsheets will keep the same format (same columns headings and same columns number).
A few words about me: I'm developing VBA macros for more than 1 years and I'm trainer for both Excel and VBA (all levels) for 12+ years. As you can guess, I have done many times similar projects, I have written a plethora of macros of any kind and difficulty level.
Looking forward to hear from you,
Kind regards,
chriskerpini