I played around with your table a little bit, didn't get too far with it, but I figured out what you definitely need to do is a query:

https://support.office.com/en-us/article/Merge-queries-Power-Query-fd157620-5470-4c0f-b132-7ca2616d17f9?ui=en-US&rs=en-US&ad=US

that will let you merge the data properly from the different tables/worksheets into one. I'm not super familiar with excel's table features, usually used MS Access, so it will take you some trial and error, but the merge query should get it done.