I am relatively new to excel and know what I want to do but little idea on
how to do it.

Background
The data is for our transport company who is carting numerous material types
from a number of locations to one central point. The company gets paid by
the tonne for material taken to this one central point.

Problem,

The template that I am working with is not a good formatt (inherited from
someone else). It has a number of worksheets all with relitively the same
information in each work sheet. Because the company is paid by the tonne I
need to have confidence in the data that any formula produces.

What I want to do,

1)Cut out some of the repeditive data entry eg drivers name, truck
regstrations, material type.
2)Ommit some worksheets by being able to filter, sort or formatt the sheet
so I can have like information on one worksheet regardless of where the
material has originated from, (currently a different worksheet for each
location or customer)
3)Create a summary page that shows the amount of tonnes from each location
for a week ending.
Any help would be appreciated