I am trying to build a spreadsheet to track the sales guys and their bids, approvals, and billing.

My tab 1 is the bidding tab. This tab included all jobs they have bid and the amount the placed the bid for.
My tab 2 is Awarded. This tab is going to be used to track once it has been approved, the purchase of parts permits, etc.
My tab 3 is Billing. It will track what we have billed on said approved job and what is left to bill.

I will also use my tab 1 to track the commissions for each of the sales guys.

Is there anyone that can help me

I need to automatically move b2 & c2 down continuously if approved and i need the approved job to automatically populate on the sales guys tab


PLEASE HELP