Trying to SQL code here, I've written a basic code, pulls through into Excel via ODBC.. on my first tab I want date and subsidiary parameters to bring back data for xxx to yyy dates and for subsidiary 1, 2 and 3.. These parameters need to then update tab 2 which has my SQL data, how would I do this please?

You should be able to create a parameter in power query to query to cell value to filter the SuiteQL response.