Excel Fleet inventory idea

[roc1479]

Hello everyone,
I'm not good at excel but i've been given the task of making a spreadsheet for fleet inventory(trucks/trailers,etc)

I have a main sheet (Main Board) which lists all vehicles by Type and Number.

I have 3 sections (Notices) to the right , which shows vehicles out of service, vehicles that are rentals and vehicles which are being requested for maintenance.

I have 3 other sheets, out of service, rental and pm used by the notices section to get it's data.

When a vehicle is added to the out of service sheet, I need it to highlight that vehicle on the main board and add it's entry to the section on the right in the color RED.

Same for Rentals in the color BLUE.
Same for PM in the color ORANGE

When an entry is removed from any of the sub sheets, the blank row is left in the Notices section.

I need something that expands/reduces as data is added or removed.
I need to have notices or flags for vehicles which are out of service, rentals or being requested for pm.

If anyone could steer me in a direction to make this more dynamic, I would really appreciate it.

Thanks

 

[roc1479]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Single[/TD]
[TD] Tractor [/TD]
[TD]Trl [/TD]
[TD]Mis[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Single[/TD]
[TD]Tandem[/TD]
[TD]Single[/TD]
[TD]Tandem[/TD]
[TD]Sleepers[/TD]
[TD]28'[/TD]
[TD]32'[/TD]
[TD]36'[/TD]
[TD]45'[/TD]
[TD]48'[/TD]
[TD]Straight[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]111[/TD]
[TD]122[/TD]
[TD]133[/TD]
[TD]144[/TD]
[TD]155[/TD]
[TD]166[/TD]
[TD]177[/TD]
[TD]188[/TD]
[TD]199[/TD]
[TD]P111[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]112[/TD]
[TD]123[/TD]
[TD]134[/TD]
[TD]145[/TD]
[TD]156[/TD]
[TD]167[/TD]
[TD]178[/TD]
[TD]189[/TD]
[TD]299[/TD]
[TD]R112[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 200"]
<tbody>[TR]
[TD]Out of Service[/TD]
[/TR]
</tbody>[/TABLE]

 

[roc1479]

Notices
Out of Service [TABLE="width: 400"]
<tbody>[TR]
[TD]Make[/TD]
[TD]Unit[/TD]
[TD]In[/TD]
[TD]Out[/TD]
[/TR]
[TR]
[TD]Truck[/TD]
[TD]111[/TD]
[TD]1/2/19[/TD]
[TD]1/3/19[/TD]
[/TR]
</tbody>[/TABLE]

Rental
Same layout as above

PM
Same layout as above

Sub Sheets
Out of service Sheet
[TABLE="width: 500"]
<tbody>[TR]
[TD]Make[/TD]
[TD]Unit[/TD]
[TD]Location[/TD]
[TD]Issue[/TD]
[TD]In[/TD]
[TD]Out[/TD]
[TD]Comment [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

PM
Make Unit Issue In Out Comments

Rental
Make Unit Location In Out Comments

The workbook will be saved daily using the days date, so over time it will create files for each day for them to look back at history.

Any thought or ideas would be greatly appreciated.

Thanks