getting items from sharepoint to excel automatically

Hi all, 

I'm using SharePoint 2013 as the corresponding tracking. all the letters will be registered and tracked from there. some of the letters has status for example new job needs to be completed by other agency. i want to link the sharepoint list with excel that can export specific items based on the title or any mechanism. 

i want to do this to create a dashboard based on that excel sheet with status and updated manually by the employees. 

or if you have another mechanism, let me know, please.