Data Input

[Shanor]

there are 4 worksheets - light, medium, heavy and total data. the total data
worksheet incoporates light,medium and heavy. is there a way when i input
data into one of the worksheets that is includes it in the total data
w/sheet. and then sort it by vehicles i.e light, med, or heavy

thanks