Hi Mark,
Yes, one may view data from one folder in another folder using 'cross-folder-queries'. Examples of how to write these queries is described in the following document page. Let me know if you have any further questions - we would be happy to help.
Greg

https://www.labkey.org/wiki/home/Documentation/page.view?name=crossFolderQueries