Use VBA to Import Data into Excel from MS Project 2013

[MeMeyer]

I am creating a dashboard in excel to display the status of many projects managed separately in MS Project. I would like to automatically import column headers and data from MS Project directly into a specified sheet within the dashboard workbook each time it opens. Does anyone have experience doing this with VBA, or are there any VBA experts who may know how to accomplish this?

Thank you!