Create report OR DataMesh to pull information from MetaData Worksheets

PeggyLang ✭✭✭✭✭

I have a client ask for a report.  There are 150+ stores involved in the report.  MOST of the information I need for the report can be found in each of the MetaData sheets.  The challenge however, is that the MetaData sheets are buried two folders deep in the Workspace.

How do I either create a report or a DataMesh that will 'drill' down in workspace then folders to get to the worksheet where the data is?