Overhead yard inventory map

Hello,
I was wondering if anyone would know how to possibly create this in Excel.

I have a few yards full of semi trailers that I keep an "overhead view" of in Excel. In other words, the ID numbers of these trailers are viewed in map form as they appear in our parking lot, in merged cells so the whole unit#s can be seen. When these trailers are moved in the lot, or taken off the lot, I move them to the proper place on the map or remove them if they have been sent out.

We keep a list of trailers in another Excel file, that are supposed to be sitting on our yards according to our computer program. This list also describes the Row# that the trailer is sitting at on our Main (largest) yard.

I was wondering if an Excel program could be created that would have Tabs for each yard map that I could edit daily, a Tab that I could import the list of trailers from my other program that are supposed to be on the yards, then another Tab or Tabs that would give me an exception report (Additional trailers not on the list, or Missing trailers that are on the list, but not on the maps).. The other catch is, I would like the list of trailer#s to display the Row# that the trailer is sitting at on the Main yard AND if the trailer is on another yard I would like it to say what yard it is in.

(Please see my attached file for a visual of what I'm basically trying to do)

Is there any way to do this?

Your help would be GREATLY appreciated because this would save me like an hour a day!


Thanks,
Ric