merging excel data 2

This is a 2 part project.. first.. I have 2 excel files file 1 has active subscription information (first name, last name, order #, amt, subscription information, date of next billing, billing cycle) file 2 has a master file of customers: (order #, customer data (address, email address, etc.) i need to create a new file that will have the active subscriptions with the rest of the customer data pulled from the master file. ------------------ 2nd part i have 2 excel files, 1 is data with order #'s i have tracked for sales 1 is data with order #'s my partner has tracked for sales i need a way to isolate the data on each file that is not in the other file.