Combine Data from different workbooks

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.