Combine Microsoft Excel Worbooks in SharePoint Folder Environment- Combine Specific Sheet in Excel

I had a powerquery that worked well when all of the folders were on the network drive but now our organization moved everything to SharePoint.  I had a critical process where I connected to a folder which had budgets in separate folders.  The query would get all excel files with these budget folders containing  the name BUDGET 2024 and it would take the PHYS sheet in each of these workbooks and combine them together.  I tried replicating this using get from SharePoint folder but it doesnt want to work with this address below.  The address has been changed for security purposes but I wanted to show you what this address looks like when I get to the folder I need to be in SharePoint. 

https://sharepoint.com/sites/Leadership/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2Fsites%2FLeadership%2FShared%20Documents%2FPCMG%20Ops%20and%20Clinical%20Managers%2FPCMG%20Operating%20Budget%2F2024%5FOPERATING%5FBUDGET&FolderCTID=0x01200048B8F4BD4C1989C9D11

The only way I can get it to work is if I change the address to the following but I cannot get to my budget folders. 

= SharePoint.Files("https://sharepoint.com/sites/Leadership/

If I chagne this to the following source by getting contents I can click and get to the budget folders but I dont know how to combine them at that point.

= SharePoint.Contents("https://sharepoint.com/sites/Leadership/

The files are contained in https://sharepoint.com/sites/Leadership/Shared Documents/Ops and Managers/Operating Budget/2024_Operating_Budget/

If I try to type that in to Powerquery into this address, it doesnt like it. 

Can someone guide me? This is a new space for me.

Thanks.