Combining multiple LOOKUP formulas

Afternoon!

So I am trying to combine information from 4 different cells in order to create a name for a device.

I have the 4 formulas needed in order to pull each peice of information required from their corresponding cells. They are as follows and in the order they need to be in. Is there a way to combine these four formulas into one?

And one additional, but not required step. Is there a way to add a - in between each peice of information?

Device Type Formula
=IFERROR(LOOKUP(PI(),1/COUNTIF(Inventory!J2,"*"&Reference!$G$2:Reference!$G$3&"*"),Reference!$H$2:$H$3),"")

Department Formula
=IFERROR(LOOKUP(PI(),1/COUNTIF(J2,"*"&Reference!$I$2:Reference!$I$29&"*"),Reference!$J$2:$J$29),"")

Site Formula
=IFERROR(LOOKUP(PI(),1/COUNTIF(L2,"*"&Reference!$K$2:Reference!$K$127&"*"),Reference!$L$2:$L$127),"")

Last 5 of Asset Tag
=RIGHT(D2,5)