Feb 17 2021 05:56 AM
Feb 17 2021 07:07 AM - edited Feb 17 2021 07:08 AM
I'll let someone else handle the Power Query option (not available on my Excel for Mac), but if you could post a copy of your spreadsheets and that source file you refer to, I also think it might be possible without needing Power Query, depending on how you've organized your existing database.
Please don't post an image; the actual sheet(s), just making sure any confidential or proprietary information is rendered anonymous. And seeing your actual data layout would no doubt be helpful to anyone addressing the Power Query side of this as well.