Inserting variables into existing Excel formulas

[AG355]

I've done some VBA before but am by no means proficient. I don't even know where to start with this

I have a quote file which consists of a summary page and a worksheet for the part being quoted. The summary worksheet consists of a single row that pulls specific costs from the part worksheet. However, quotes can be for a single part or multiple. When multiple parts are involved the first part worksheet is copied, renamed appropriately, and then completed.

On the summary sheet what I have to do currently in the multiple part scenario, is copy and paste the summary row for the first part into subsequent rows and then manually go into each of the 11 formulas and change the worksheet name to reference the next part information. This is tedious, time consuming and prone to errors.

I have set up each worksheet name as a variable but can't figure out how to insert that variable into the existing 11 formulas so it references that worksheet. The only thing I can find is incorporating a formula into VBA to do a calculation, not inserting the variable into an existing formula.

Thanks in advance.

 

[arthurbr]

Perhaps have a look at the INDIRECT function?