Help with Excel, merging workbooks
 

I have to keep a listing of companies that are exhibiting at a conference. I have the initial excel file of the first responders. For the next few months, I'll be receiving additional listings of 2-20 more responders in excel files. These need to be added to the original file, in alphabetical order. Is there anyway other than cutting and pasting each individual listing to merge these seperate workbooks? :confused:

I don't know alot about excel
But here is what I found
Hope this is helpful
How to Merge Workbooks in Excel

Microsoft Corporation

As far as I've seen, Microsoft's "share and merge" system is just a glorified copy and paste with a few more steps. If you were getting all of the spreadsheets at once, you could try it.. make all the new ones shared, and merge them into the old one. However, since they're coming in sporatically, you're probably better off just pasting it to the end of the old workbook and resorting them.