How to add dynamic table for data entry that also has a scroll bar

Hi Everyone,

I've been working on a document for my job that is, in short, going to be used for estimating jobs. This will require the user to choose resource types (engineering, installation, etc..) as well as number of hours for each resource. There is also an equipment tab that is for entering what equipment is required and how much it costs.

In the "Installation" tab, I have 3 separate tables for 3 separate phases of installation, each requiring entering the resource types and number of hours. I have these tables kept fairly small so it's easier on the eyes, but some odd jobs may require many many resources, so I want to find a way to be able to add rows to these tables, while keeping my formatting, formulas and data validation in place. I can't have a button to insert rows for all 3 tables separately, since that would mess with the formatting a whack of other issues. I've deleted a lot from the attached workbook just to keep things simple, but the true document is filled with dozens of tabs and lots more data beneath these tables that I want to be easily accessible! I would simply have a different tab for each phase of installation, but there are already too many tabs, and I'm trying to simplify this for each department that needs to use it.

Ideal Solution If Possible: I want to be able to have a dynamic and scrollable table for each installation phase (ie:, for Installation Phase 1, that's D10:G17), so that if someone needed to have say, 40 resources for the Phase 1 installation table, they could simply scroll down and add more instead of having to insert more rows to that table, thus adding more rows to the entire worksheet. Can I have that range be scrollable? Can I add rows to that scrollable area so it's not scrollable right away until it's needed?

I just really need this table to keep the data validation in column D, while also keeping the formulas in columns F & G for any new rows that may be added.

Any help would be GREATLY appreciated, as I have been spending a ton of time online and watching Youtube videos trying to figure out how to do this, but to no avail. Hoping it's possible! Or, if you have a better alternative, I'm all ears