You need to have different workbook created for each data source in that way we can achieve that. We cannot switch the data sources dynamically for workbook .
Thanks, looks like we may need to upgrade to v10.
A possible option you have is to use a parameter in a custome sql.
If your data is coming from a DB
you can set up a parameter of client ID or name and use this in custom SQL to generate the data.
You can now pass this parameter value in your URL and visualise different clients.
I did try to do this using dynamic SQL in a Stored Procedure, but the performance was very slow.