Comparing multiple Excel Spreadsheets

[rogueakula]

Here is what I am trying to do...I have multiple .csv files all with the same information. Column A contains a name and column B contains a value. I will have up to 47 of these files each with about 400 rows. What I am looking to do is compare all of these files to each other and find the differences. Ideally, what I would like is to be able to open all these files in separate tabs in a workbook and then have another sheet list the differences, i.e. - sheet 25 row 256 "does not match". I know that I can do conditional formatting but that still takes manual manipulation. I am not much of a programmer but I do have some knowledge in c++ and python. Any help you guys could give me to get me going in the right direction would be great! Thank you so much for all your help!

-Josh