Need to pull data from a spec worksheet into a summary and run formulae from the summary

Hi All,

Desperate for some help on the following conundrum.

I work for a professional services company who create quotes on excel worksheets. What we want to do for each department is pull the summary sheet of these quotes into a workbook that summarizes and plans the departments work.

For example we have, 7 stages for each quote, each taking an identified amount of days, so this the table below shows the information that we are gathering on the summary sheet.

data capture.png

There are calculations behind the L1/L2 metrics columns which are calculated from the quote page (calculations based on risk factors etc.)

Is it possible to build some code that would identify the last worksheet to the right of the workbook and then create the new formula based on the worksheet for each of the 7 stages?

hope this makes sense!!

Cheers,

Ryan

Ryan,
Welcome to the forum!
Please attach a sample book, not a picture. When you attach a book, you should ideally show your desired result. You have few sheets and another sheet which shows how the appear on the summary sheet. All in one book. To attach a book, go to advance then attachment.

Programme Project Tracker for forum.xlsx

hiya, lol sorry, new to these forums to be honest.

Document attached.

Thanks,
Ryan