Combine Data from different workbooks

I hope this is a better example, this data is just test stuff.If this can be done, what do I need too read up on. Not sure where to start, could I use Query for this?. I made a couple of test books as examples. The first two books have some matching data, will I be able too delete the matches and combine the two books on book3.
If you have some input on this "Thank You"

Thanks royUK for your time looking at this, no the books will be closed,yes they are in same Dir,yes the header will stay. Not even sure this can be done.

Bump, has anyone ever did this, or should I look for another way?

Bump,Bump Any ideas on this,where and what should I read.

Maybe this will be better,If I only have 2 books. Here is a example, I can make this work if it can be done. Not sure how too go about it, Marco? Query?

Larry.

Roy I changed it to try and make my example easy. Been doing a lot of reading and I think merging would be better. Here is my other workbooks.I will keep both workbooks in a dir called C:\test.




Thanks

Thanks roy, I'm a little slow on this stuff so please bare with me. Do I place both codes in the Journal1 book? I have both books in a directory called invoice. Are these code for the two journals I posted last.
Thanks

the journal1 & 2 are closer too what I'm doing. I have too workbooks with the journals on sheet 4 and I hope too make the code work on them. I did what you said and must be doing something wrong. Here is my folder, when I run this will I get all entrys on the journal too one sheet?.

roy Please bare with me and don't quit on me. Thank you very much on helping me, just not sure whats wrong. I have put these 3 workbooks in the same forder. When I run the master it asks what folder and I go and pick it. But when I run the marco in the master nothing happens? I know it must be something I'm doing, you taking a lot of time for this and its looks real good, exactly what I want too do.

OK roy, making progress, I'm able too pull the data from the two books. What I only can get one book at a time, if I do the other book it deletes the other data. If I can I want all data too stay in the master.

hello roy
I not good at explaining on what I want, let me do it in steps
Get the data from both workbooks and save it too a master journal
When I input data in one of the workbooks I want too go to the master journal and update. The journal will store all entrys. Can this be done, sorry if I confused you. You have been a great help.

would it be better if I just post my two workbooks?

Thanks roy, here are the two workbooks I use. Both books have a journal on page 4, what is the best way too combine the data in the journals. The books are a mess now,been working on them, I will clean up. The invoice number works for both books, I just need a source too combine all data in journal. The journal helps be keep track of payment. With the setup I have is this possible too do? Maybe the journals could merge somehow?

I'm getting lost again,roy I use both workbooks because my jobs are different. I guess I could do a hole new workbooks with both types of daily jobs but that would be a lot of work. For now I just looking for a easy way too combine my journals. Now I have too open both books and search the journals for what I need. I look at the other examples and not sure how it will work for me, so what I want do do would be real hard? I can stay with my old way if it going too be hard too do. You been great working on this for me.
Thank You

roy a separate journal book will work if I can save both books too it. Is they a way too save to a journal book instead of page4 in the books. I do not have too have that page if I can have a book. I would name it Jornal Book and put it in the same folder as my workbooks. What type of code would that take?

Let me know if you want to write the details straight to a master journal , yes if this can be done. Can you write too a workbooks that is closed? Will I be able too do the same with my 2 day form. All I need is the info that is on page 4

one other thing, could I merge my oneday into my twoday for one book?

Thanks royUK I will input it into my form now, its nice too have help from a expert.

This layout is better than nice royUK, here is a dumb question how did you make the list box in the rows. I want too change my hole invoice now LOL. Just not sure how too do the list box?

I got it, just a little slow LOL