There is currently no way to redirect a worksheet to new data source after it's already been built in the desired workbook. One option is to create a bookmark as a 'template' that can be used in multiple workbooks. Then, each time the bookmark is used, it can be redirected to a different data source. The following link provides a little bit of insight on how to do this:
Hope this helps!