Combine Data from different workbooks

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