Refresh Azure SQL Server from Prod to Test across different subscriptions and regions

your logic is sound--however, this will be a heavy lift for someone without extensive PowerShell experience. There's probably not a lot out there in the gallery. I'd work with the Learn modules for automation here. https://docs.microsoft.com/en-us/learn/modules/explore-azure-automation-devops/ to get more comfortable with automation and PowerShell.