How to Construct a Formula Based on Text In Changing Cell
 

Please Help!

In short, I have an inventory control spreadsheet that generates a new
SKU for each new item entered into an input sheet. Inputs are then
copied to a template sheet, which is then copied and renamed to the
SKU.

I would like to have a summary page that lists all SKUs and beside
that references specific cells within the SKU's associated sheet. In
an ideal world, this summary page would be updated each time a new SKU/
sheet is created.

So, my progression would ideally be something like:
1) After new SKU/sheet is created, switch to Summary
1) Find last row of the Summary
2) Go one row below the last row of data in the Summary table
3) Insert new formulas for most current SKU just assigned based upon
contents of K4 as being last SKU created.
4) Row on summary displays the last SKU/sheet created, its
description, the book quantity, and current weighted costs as per the
associated sheet.

In an even MORE ideal world, each new SKU would link to the sheet and
this would be done automatically, but that can wait.

Anyhelp would be much appreciated as this is the final step I have to
complete this particular project I've been working on.