Hi alanantwon,
I know excel macro very well and will complete you task very soon.
I have gone through your attachment file and understand your needs.
I want to over you another solution since more of process portion are done in excel, I proposed to convert it to excel macro template, here the part that i will create for you if you are interested on it.
#. Create VBA excel template with user interface to import your ms project file, processing & formatting into your excel format as per required.
Here is my Portfolio link : https://www.freelancer.com/u/gsanggara
looking forward to hearing from you.
Regards - GS Anggara