I have 4 worksheets in one workbook. 1 of those sheets is where I put names.

I would like the other three sheets to match. I know I can do = and the cell info and that will pull it over.

My question is if someone adds a row to the Take Order sheet. How can i get it to add that space to all the other sheets or is the only chose to do it manually each time?

Thanks