How to merge specific data from tailored coded worksheets in a workbook?

Hi there,

So I created a workbook to keep track of events. This workbook includes:

- a calendar - where you can list what activities (under tab 'Activities') are going on throughout there year and it will show up on the calendar (under tab 'Calendar')

- A contact sheet - where all contact information are located (under tab 'All Contacts') and using a specific information like their IDs can auto - refill other information in other work books namely events.

- Also features are drop down lists in like column 'programs funded'

my question is how to I merge all this data?
like lets say I want to know what events this person went to in the past year. It would show me their
PMID-Name-Events1-Events2-Events3- and so on...

I attached a sample sheet