I think you can use the JOIN function in this situation

= "SELECT * FROM " & JOIN(Parameters!DatabasesOnServer.Value) & ".sys.tables

Actually, you need a while loop which takes the parameter selection(s) and iterates over the SELECT * FROM [DataBaseNameGoesHere].[sys].[tables] AS T replacing the [DataBaseNameGoesHere] for each iteration.