To run the office script on power automate, your data needs to be on one file. You can either move the data to one file and run the script using 'run script from SharePoint' by storing the script externally. (built in / office embedded scripts often don't work properly)

or

other option is to fetch the source excel data to power automate, do the necessary lookups via filter array and similar actions and inject it back to the destination excel.