Workbook with Summary Table and Dynamic Data Input to Worksheets with Calculations

I have already created the workbook which works effectively when I import data into each tab and the data (table arrays) fits my current vlookup calculations. When I import data tables which doesn't fit my static formatted formulas, I get bad calculations at the top of my sheet (which feeds into a summary table). I need to be able to import/paste and formulate my calculations allowing for dynamic data tables.