Work related SQL question/excel/power BI

background, i'm a production manager and trying to create some tools for supervisors to track metrics. I have limited IT support and major constraints on what applications I can use due to company data protection policies.
I'm trying to make a tool that makes my day easier. I have the ability to pull from our ERP system's data tables into excel.
My idea is to create tables that display work in each cell, who is logged into each cell, what the average time spent on each part is(closest I can get to standard labor) and if someone is on a part. So now I have that info I can create a dashboard that shows me how my labor utilization is going and even the efficiency.

I'm pretty good with excel but just can't visualize how to make this functional on 1 screen so i can have them on display around the shop for leads, etc. Is power BI the way to go for this? If so can power BI pull data from a sharepoint file(excel) that is set to background refresh, is that even the right way to do this?