>There are quite a few that will pick out what the table is that is in the currant workspace, but is there a way to get them all without selecting each one and getting the name individualy?

Within a single datasession, yes; take a look at the AUSED() function, which populates an array with the aliases in use and their work areas for a single datasession. It is scoped to the datasession, so if you're using private datasessions, you'll need to execute it separately in each datasession.