Trying to create an excel spreadsheet for HOME DEPOT products

[Nate Narcisse]

Hi BP family,

I'm trying to build a template excel spreadsheet, which would include products and pricing for materials from Home Depot. Also on this spreadsheet would be different labor rates from local contractors and the square footages of each material needed  (depending on the level of Rehab). I know every rehab/remodel is different. So I figure, the best way to go about it is to rehab for the worse case scenario, which would be a full gut remodel for every part of the house. That way, I could get an idea of the cost for the most work that could be done on a house, if that level of work was required. If the house doesn't need that much work, based on the comps, then I could simply deduct from the large rehab figure/estimate and call it a mid-size rehab or a light rehab. It would be nice to have all this information in one place, hence the spreadsheet. Not to mention, it would be a nice way to estimate accurate rehab cost and creating a budget ( once I get a measurement of each room). There's a few problems I'm currently facing: 

1) How do I go about getting that information and structuring the spreadsheet? (Home depot doesn't really have a price book for all the material they sell)

2) Would I have to manually redo/update the pricing, every time the prices change? (If this is the case, then I may hire a VA to do the work)

3) Am I better off going to a different material supplier for each individual product instead of Home Depot?

Any ideas?