Gathering Data from Workbook onto a New Sheet. Need help with work catalog!

Hello! My team has an excel library to sort different things. Each item is sorted by shelf #, then a corresponding number for the type of category, then the consecutive number it is. example S1-2-1126. 

We can search the name of the item and quickly get the number and easily find what we are looking for. 

The problem is that when we need to add something to our library it takes a while to look for the last number used because they are spread over three sheets based on the year received. Is there a way to have all the numbers sorted onto a single page using a macro or something? Thank you!