Dynamic Auto Populate

Hey All,

This is my first post. There's a ton of smart people here who have been extremely helpful even before I finally registered.

Down the issue.

I have a large file with a lot of data that corresponds to different machines doing different loads of business. Some machines get added and others deleted over time. I have organized my file so that I can manually input data into three separate worksheets. 'Raw Data' is populated by terminals that remain constant. 'Added' is populated by new terminals for the period, and 'Removed' by terminals that have no data for the period.

I am looking for a way to automatically populate an aggregate worksheet that is able to organize all of these terminals by state location. The ID numbers for each terminal correspond to the state they are in, so sorting that column will allow for that arrangement.

From this aggregate worksheet, I am pulling the data into an analysis spreadsheet that will break each state down and subtotal various aspects of the data. After the data from each state is listed, I will subtotal and average various columns, then again repeating at the end with a total sum and total average. My problem then becomes alloting space for the added terminals, and removing the ones that are no longer in use. Is there a way to insert a row and automatically fill it with the given data?

My problems are arising because of the dynamic nature of the desired file. I was able to create a static version of this with generally little difficulty.

Thank you in advance for all help.

Here's a sample. It's secure data, so I plugged arbitrary numbers.

Hope this helps.