Data consolidation into Data Model

Hi All!

I have two worksheets linked to a SharePoint database with several columns of dates corresponding to different IDs. I want to pool all of those dates together so that I can see what IDs (with accompanying descriptions) are coming up this upcoming week, month, etc.

date table tests.JPG

Right now, I run a macro to do this manually. However, every time I refresh my linked data, I have delete my old table to run the macro again.

Is there an easier way consolidate all this data together through a single pivot table, and have each column header and table called out? It would look similar to my manual macro generated table, but would be able to update dynamically. I have Excel 2016.

Thanks!