Fleet tire depth tracker

[aachoudh]

Hi guys

I am in the need of tracking tires depths in my fleet, i want to be able to put data in another sheet of all 6 tires on the trucks, and then it be updated on another sheet, i also need a conditional formatting for when the depths reach 4.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Truck#[/TD]
[TD]FR[/TD]
[TD]FL[/TD]
[TD]RR[/TD]
[TD]RL[/TD]
[TD]RRR[/TD]
[TD]RRL[/TD]
[TD]Date Inspected[/TD]
[TD]Date Replace[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]22[/TD]
[TD]22[/TD]
[TD]22[/TD]
[TD]22[/TD]
[TD]22[/TD]
[TD]22[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

As you can see here i want my data to be placed like this on the main sheet that everyone can access, i need for it to pull data from another sheet in the same work book, and i need it to change yellow on the main sheet when the depth goes to 4, Please help me create all this. Also i want this main sheet to keep updating and automatically adding a line everytime i put in a new update from the other sheet. Please help

 

[peterhinton]

try using a pivot, then looking for some code that will update the pivot each time you add a new line

 

[aachoudh]

Im having trouble all around building this sheet, my pivots arent working, im trying different formulas/codes its not working, please help me build this sheet.