vlookup to capture asset purchase totals and depreciation

Trying to come up with a few formulas that will calculate depreciation based on a purchase date so it'll populate in the appropriate columns (I have the first year by quarter and the subsequent years annually). And then also to pull the asset category from the first schedule onto another page, to total the asset purchases and the depreciation, again by period. Hope this makes sense, and that my attached spreadsheet is clear! Having trouble explaining what I'm trying to do so I apologize in advance for any discrepancy!!

Thanks for your help Excel Gurus!!