I have the answer, which requires some Excel functions.
The first step is to call for the location, and sheet number in two separate cells:
Then, make a "Zone X" cell, a "Zone Y" cell with the following respective functions:
From there it is some simple concatenation, I chose to break my concatenation up into two stages. The first is combining the "ZoneX and ZoneY" cells, called "DRWG ZONE". Then combine the "DRWG ZONE" cell with the sheet number cell from up above.
Hopefully this can help anyone in the future who has similar needs.
P.S. Although I know how to program, I did not come up with those for the Y and Z zone functions on my own.
EDIT: my bad, I forgot to mention that those cells being referenced "F7" is the location cell being exported from Inspection for that specific feature.