vba required for complex spreadsheet

I have a spreadsheet with some vba requirements and due to my lack of knowledge on vba, i need some help. I was wondering if I could get some help on a complex issue I posted on a forum mrexcel.com by an excel expert of microsoft please?

https://www.mrexcel.com/forum/excel-questions/1089760-transferring-between-workbooks.html?highlight=transferring+between

Thank you,

Dave