Customize multiple workbooks

Registration date
Wednesday November 26, 2014
Last seen
November 26, 2014
I am currently working on attempting to consolidate excel workbooks in that I am looking for a way to input in one workbook and have it transfer to 2 other workbooks is that possible....I am looking to keep up with a maintenance log and am having to do so in 3 separate workbooks. Is there a way that I can set up a formula that would allow me to enter the information once and it show up on all three? And is there a way within a workbook to have a row that has not been completed transfer to the next sheet....for example if car A was supposed to be fixed and a work order put in but it is not marked completed so it transfers to the following sheet?