> There's VBA in excel, but I'm thinking about more like dynamic table that's linked to an endpoint

I believe Excel has PowerBI for this purpose.