Quote Spreadhseet help

Good morning. I need your help. I created a spreadsheet to quote some products. The spreadsheet has some sheets to estimate costs, and has a summary sheet to collect most important information. Data on summary sheet are linked to estimate costs sheets, so I need to change manually linked reference on columns C, D, E, G, J, K & L. Is there any way to specify once sheet name on column B, and then columns mentioned above automatically be updated ??

You can use the INDIRECT function to do this. See attached revision of your workbook.

However, you have circular references that are messing up the results.