Consolidating nutrition and price data from multiple sources into one Excel dashboard

When you are pulling from sources that you don't have any control over and no guarantees from, there is no way to make sure something they do won't break the process.  The best you can do is try to detect changes and give warnings.  For example if you pull in that first table from the McD's site you will expect to have the following headers:

so you can check for those headers and output an error if that isn't what you received.

i would recommend one or more extra tabs for things like conversions, configurations, and settings and you can have tables for currency convresion and unit conversions and such to make it easier to see and use.

but in the end you are looking at complicated power query and/or lambda functions so anyone else inheriting it will need to be relatively savvy in excel to understand how it is working.