A macro to combine multiple worksheets

I have been trying to find a solution to my problem for a few months now and I have, thus far, been unsuccessful at finding a sufficient solution.

Just to give a bit of background info: I am a biologist working with formulas to distribute hunting pressure across the State of New Mexico. I have a worksheet for each Game Management Unit in the State and each Unit contains its own hunt objective. We have properties that fall in multiple units (all under a unique identifier), and these are causing the major problems.

I have about 40 worksheets that have the same header information in rows 1 through 7, but a varying number of rows below that information (from a few to 200). Row 8 is the first row with differing information on each worksheet.

I have been trying to come up with a way to combine all worksheets into 1 worksheet and have Excel combine all instances with a unique identifier into 1 summed row (i.e. if a property has 1,000 ac and 1 tag in Unit A, and 4,000 ac and 4 tags in Unit B, I want the final to have 5,000 ac and 5 tags). Not all properties have more than 1 entry, but some have 3.

Ultimately I would like to run a macro each time we need the single worksheet with all properties listed on it, but haven't been able to figure things out (I am not that good with macros).

I have gone through and done things manually and it takes about 5 hours and I make mistakes. I would like something quicker and more foolproof than I am.

Any help is greatly appreciated.

Ryan