Displaying values from multi-select dropdown boxes from different worksheets on one worksheet

[GHVDS]

I really hope that the thread title adequately describes the issue I currently have...

@John_w has kindly given me a very good solution for deselecting from a multi-select dropdown, which was an issue that had me puzzled for a long time.

I now have a workbook with 3 worksheet (sheet 1, sheet 2, sheet 3), that each have two multi-select dropdown fields on it. I want to have an overview worksheet that allows a user to see the scores of each worksheet next to each other.

I tried to copy the multi-select dropdown fields from each worksheet and "Paste Special - Validation" on the overview sheet. However, that doesn't seem to update as I change the values in the dropdowns on the sheet. Can anyone advise me what my best course of action would be?

I have used the VBA code from @John_w on all worksheets.

I look forward to any advise!

Thanks
Geert