Querying details from the Sheet Name
I have several folders corresponding to different projects in a workspace. In each folder, there is a master file containing details of the project. All the projects schedule logs are referred to as 01 Project Schedule. When I run a report to query on delayed activities from the different projects, I get the following. I would like to know how I can differentiate from the different Sheet Name. Is there any field that can provide the name of the folder where the file is located? Or retrieving the hyperlink behind the Sheet Name? Thanks.