Yes, this is possible.
You should be able to create a second data source in the same workbook using the other table.
Some screenshots could help us to guide you on where you might be going wrong.
Hi Phillip - looks like I was adding a "connection" instead of a data source. Whoops.