Need Excel help

Job ID: 34389476

Budget: $750 – $1,500 USD

Wanting a spreadsheet to track costs on construction projects. Ideally I could copy transactions from our bank and credit card online accounts, and drop them into a costs spreadsheet where I could label them for specific named projects and note wether they were commercial or residential. From that spreadsheet I would like to then move or copy individual costs into another specific job spread sheet that they are costed to. (A master copy of job tracking sheet that I could create a new job sheet each time we open a new project) The goal would be to track costs, profitability and budget for each project. I could enter the contract amount and change order amounts at the top, then add costs as they come in. Also, would like to track:
invoiced amounts and payments made/due. Expected and actual profit margin. Start/invoice/payment dates.
Then, a third spreadsheet that would track the significant cumulative numbers of all the cost tracking projects sheets. For an overview of all the projects