VBA Script for Reporting on Mac

I need help exporting a singular sheets desired plot area to PDF, where the path and file name are determined by cells within the sheet. This is for a property management excel sheet, where the desired file location and name will change for each Tennant. I also want a teams meeting so I can be walked through the process.

Note, I am on a mac computer