How to pull data from a report to a sheet?

I'm currently trying to create a sheet where I can pull data using a formula from a report, I've tried to do DataMesh & Pivot to no avail, would there be any way or formula where I can use a report as a source sheet? Also, can DataMesh mimic a report instead of a sheet? Thanks!