Database start

If you have Excel 2016 or more recent then Get & Transform in included. If you have the 2010 or 2013 version then Power Query is a free download from Microsoft. (Please put the Excel version in the profile for MS-Off Ver: )
Using Power Query you could:
1. Convert the range on the Events sheet to a table (tblEvents)
2. Make connections to the three tables in the workbook by selecting the Data tab > From Table/Range > (Power Query Editor) Close & Load to: > Only Create Connection
3. Merge the three connections using the following advanced editor code:

let
    Source = Table.NestedJoin(Master, {"member ID"}, tblEvents, {"member ID"}, "tblEvents", JoinKind.LeftOuter),
    #"Expanded tblEvents" = Table.ExpandTableColumn(Source, "tblEvents", {"MOMA", "Circus", "Show", "Garden"}, {"MOMA", "Circus", "Show", "Garden"}),
    #"Merged Queries" = Table.NestedJoin(#"Expanded tblEvents", {"member ID"}, SSales, {"contrubution ID"}, "SSales", JoinKind.LeftOuter),
    #"Expanded SSales" = Table.ExpandTableColumn(#"Merged Queries", "SSales", {"Quarter1", "Quarter2", "quarter3", "quarter4"}, {"Quarter1", "Quarter2", "quarter3", "quarter4"})
in
    #"Expanded SSales"

Let us know if you have any questions.