How to automate owing page in Google sheets?

I use Google sheets for my window cleaning work. It's broken down into 4 weeks. So each road is assigned To a certain week. When I have a customer owing me money, I have the figure show up in red. What I would like though, is for any road (every sheet is a separate road name) to automatically appear under its selected week in my "owe" sheet and the total cost that road owes next to it. Currently my "owe" sheet is done Manually.

Attachment image
There are no answers yet.
Be the first to answer this question.