Excel Formula for Finding the Last "S" number used

[Aklouzek]

Good Afternoon!



I am trying to pull information from several tabs onto a cover sheet. The information i am trying to pull is the last or highest "S" which is a serial number that has both Letters and Numbers in it. Can anyone help to point me in the right direction? I have attached a couple snips to give you an idea of what i am looking to try and do. I need to be able to see what the last/highest "S" or serial number was used for each department at a glance, pulling the information from different tabs to the cover page that I am building.