Read VBA code dynamically (sample code provided)

Freelancer is required to perform the following:

Instructions for freelancer (also attacted file)

Double Click B2 or D2 to open pop up message to select xlsm file.

As soon as the file is selected, do the following
Perform steps mentioned in step "When user delete file name from B2 or D2"
Read all macros in selected file
Put Macro Name from row number 5 onward. Note, when macro name is already present in other column, then put name in same row.
If sheet already exists, then put entire macro content in the existing sheet in col B or D (respectively). If sheet do not exist then create a hidden sheet and insert contents.
Perform comparison of code, and highlight row 5 onwards as green or red.

When user delete file name from B2 or D2
Delete all Macro names in col B or D (respectively) from row 5 onwards (including fprmatting).
Delete macro contents in col B or D (respectively) from all hidden sheets
Delete all sheets (except Setup & Main) where macro contents are not present in col B or D (respectively)

[Fixed price: £15]