I've looked through a lot of other questions that are quite close to what I'm trying to achieve but aren't really the true outcome I'm looking for so my apologies in advance if this seems too close to a duplicate question.
Situation
I've got a Excel workbook with multiple sheets in. One of...