Excel Power Files
If you want to get serious work done in Excel, you need to make power files. These files are already formulated to do everything you need to do. All you need to do is plug in new data into to them and let the power files do the work every time.
You might have a power file that knows how to extract data from a field. I have one of those. Just plug in new skus into it and their descriptions.
You might have a power file that already has xlookup formulas. When you download a file and save it as the source, your power file will automatically do its work on it. I have some of those. If you don’t have power files, you are wasting a lot of time.
When you add macros to the mix, now your power goes exponential and I have those too.
Stop rebuilding the same crap all over again. Make power files. Dump data into them. Take an extra coffee break.