Automatically updating Pie Chart Title

Hi,

Hope all is well. Just hoping this is possible with a VBA. Currently have to update a few Pie Charts Titles and would like if I select a dropdown of a Quarter (J1 for reference) that it would automatically update the number.

Example in the attached document if I select Q2 - 2020/201 then for Site 1 in Q2 - 2020/201 it would read Headcount: 1500 pulling from Cell F5 on the All Data Spreadsheet.

Thanks