Thanks Steve-
I have three workbooks due to them being in different locations and w/ mulitple sheets. I only used the example for simplicity reasons.

One workbook has numerous sheets that support the creation of new records.
One workbook is the nucleus of the other two and actually has 9 sheets and will expand.
One workbook is sent off for data entry.
Unfortunately I cannot have them all update and run at the same time.

One thing I am exploring is finding the last row +1 in Book2 and writing that value to that 1st unused row.
I am thinking I can pick up that value as my variable the next time I run the code.....
Row 86 is the first unused row currently, so if I find the last row, add one and place that value in the first unused row then I have a starting point.
I have code up to writing the value. I am working on code to pick up and insert this value in my code.
Never tried this.....

But this is not a very clean way to do it.... I will have a orphan value in my sheet that will get written to Book3 now.... so I have to delete this.... but it might be the only way.