So I'm punching everything into a workbook so that I can keep a record of workflow.

I've butchered the code to: hide column E (link), add in a sort by descending order (column A) plus a link to the spreadsheet based on column E (no longer need shortcuts stored).

This is all to keep track of the data sent in by surveyors and to maintain my own workflow.

Thanks again to everyone for their help and ideas.