Auto Tabulating Materials Spread sheet

Hi all,
I'm a field engineer for a power company and we are trying to figure out a way to automatically tabulate materials called for on a build sheet. Basically the current process follows the below steps.

1. Enter materials needed at each location on the current excel spreadsheet. (each location to be worked gets a separate row and each row has different columns for different types of material).

2. Once the staking sheet is completed we have to go back and manually count each type of material to get total materials list.

I would like to build a spreadsheet to eliminate step #2. I would like the spreadsheet to automatically tabulate the materials either as I enter them, or via a 1 click command like a button.

This is our current spreadsheet, as you can see it is basically just a form.

Overhead Staking Sheet.xlsx

We have in the past used spreadsheets that auto tabulated, but they always relied on look up tables and if you had not typed your material name exactly as it appears in the look up table, it would be skipped and you wouldn't know. I have considered using a drop down box to allow selection of materials but this becomes problematic due to our large number of some types of materials. Any advice you all could offer is greatly appreciated.

Thanks,
Tom

Sure thing. Below is a completed sheet from a job I just sent out. As you can see, there is a tabulation section on the bottom of the
first page which summarizes all the materials needed for the job. Anything with a "*" next to it is a unit to be removed.

Russell 5 RC Staking Sheet.xlsx

Tom

Each row represents a pole location. Add is new materials. Ex is materials to be removed. Each column represents a material category. each pole location will have a list of materials. I need excel to count the occurances of each unit and add it to the tabulation sheet at the bottom of sheet #1.

I.e if there are 4 occursnces of VM5-9 under the misc. column header I need excel to add VM5-9 to the tabulation sheet and a count of how many times it occurred.

Tom