Power query on mac from table/range

Hello,

I recently created a series of VBA macros on excel for windows. It uses power query to sort and compile data from multiple sources (within the same excel file); it works across multiple iterations of excel for windows.

I am trying to get the same file to work on excel for mac, version 16.35 to be exact. I have identified which macro is not working, and it is the one that refreshes the power query. I am wondering if power query works for mac when it is compiling data from tables/ranges within the same excel file, or if that functionality does not exist yet and I am barking up the wrong tree. Does anybody have experience with this issue?

Thank you

Thank you; it looks like Excel for Mac does not have Power Query from tables/ranges yet. Are you familiar with something that can produce the same output as power query without using power query itself? I'm fairly new to VBA, but maybe I'll try to make something that automatically pulls the data from different sources