How to create a summary page from data that is on the recipe pages only|VBA & Macros|Excel Forum|My Online Training Hub

I have written a recipe program that can scale recipes for a Meals on Wheels Charity I am volunteering for.

This question is about how to get data from each recipe page only create a summary page showing the - recipe name, sell price per portion, CoGS, and Gross Profit on the summary page instead of typing them individually. Many more recipes will be added in due course and the order of the Excell worksheet recipe change sometimes.

I am using a PC with Office 365

I am not sure if I can do this with formulae only or if I need VBA which I believe currently is the best solution.

I managed to learn how to create a table of contents with hyperlinks, but this is beyond my current skill level. I am also open to any suggestions to improve what I have done

the link is  https://www.dropbox.com/scl/fi.....khf64wykar

I am not up to date with sharting files I hope this works

Thanking you in advance for your support and advice

Henry