@SamT

I thnik you'd better apply for a Job at Joeny's.
I don't think Joeny can tell you what the process in total should look like.
He has been given a task that hardly matches his comprehension and a tool that has been designed by somenone else who hardly knew any VBA.
Like PH suggested: redesigning should be done first.