Add Multiple dates in Column per number

Hello,

I have a table of numbers that come from another table, another table with the same numbers and names, and a third table with the same numbers and dates.

I need to add a list of values for each number so that I can summarise data for each year in a table.

All the tables have ralationships to Table 1.

Essentially I have this:

Table 1

Table 2

Table 3

The desired result is:

I hope this explains what I'm trying to accomplish.