I am very green when it comes to excel, but I am learning. I would like to know if it is possible and how to make this happen.

I want every row I create in a book to copy to the first book. So every row I make in book 2, book 3 and book 4 automatically copies the information into a new row in book 1. Is this possible and how do I do it?