I'm finishing a project which I could use some MAJOR help with.

I have a workbook with location names (Richmond, Va) on sheet1, column A in
three groups (A, B, C) There are titles, sub-totals, empty rows between the
groups.

I have three named ranges for the numbers in Column B for each group, A, B, C.

Each location in Column A is also a hyperlink to a corresponding worksheet.
The worksheets are in order of the location names. Each location has a unique
location number (123) in column B and data/formulas in columns C-I. (5 data
sources come from constant cells on the corresponding worksheet with sums of
this data on just that row, but each section uses different cells depending
on the format of the worksheet).

Each group has it's own worksheet master format. These masters are at the
end of the worksheets in A, B, C order.

I add/delete many locations to each group and need a macro that will
add/delete rows and the corresponding worksheet, create a hyperlink to the
new worksheet and update the formulas to the correct cells on the worksheet
based on which group/worksheet type was added.

When adding a worksheet, I need a macro that will do the following:

Insert a row based on the row number input by the user (MsgBox)
Insert a location name input by user (MsgBox) in Column A on the new row
Insert a location number input by user (MsgBox) in Column B on the new row
Select/Copy the correct worksheet formatted for the group where the new row
was added. (If in group A, use A worksheet)
Insert the new worksheet in the proper order based on where the new row was
added in the group.
Rename the new worksheet based on the location name in Column A (there may
be duplicate names so the macro needs to check for duplicates and if found
can add a suffix for the group added to, such as Richmond, VA_B if Richmond,
VA exists in group A already. I could do this on all of them to eliminate
checking the other worksheets as they would all be unique.)
Create a hyperlink to the new worksheet in Column A of the new location added.
Update the data links in cells C, D, F, G, I to the correct cells on the
newly named worksheet for that location. (Each group uses different cells on
the three different sheets...if you give me the method, I can update the cell
addresses for each worksheet type)
Update the formulas in cells E, H (sums CD, FG) like the formulas in above
cells.

When Deleting a row, just need to delete the the row and it's corresponding
worksheet.

I would really appreciate someone taking this on! Many thanks in advance!

David