It would be better if you formatted the costs sheet and put some actual data for a couple of days on there so we can see what you want it to look like.

Having it update automatically might make it run slow.


If the code has to loop through all the sheets every time you change an item, add an item, delete an item, change the quantity, then you might see a noticeable lag, maybe not, but I'm just letting you know.

It might be better to have an update button or just run the macro from a key combination like Control + q.