Regroup data from several Worksheets into one without keeping duplicates.

Hello,
I've put together a Excel file containing Magic cards I've collected wherein I organized my collection. I'm having several problems with the spreadsheets below. Now I'd want the data collected and regrouped into one single spreadsheet to import it in a magic collection program and if possible all duplicate cards removed.

Details:
First I need to have the data consolidated into one single new Spreadsheet. Only the columns "Card Name", "Card Set", "# Owned" and "# Foil Owned" should be used in the new Spreadsheet as well as an additional column named "Date Merge" in which is marked when the data was consolidated. Now this should be as dynamic as possible since I'm going to be adding data every 3 months.

After having all of the data regrouped I'd want to delete the duplicates in column Card Name and just keeping one original cell but suming the columns "# Owned" and "# Foil Owned" into two respective cells.

Here's the thing explained via screenshot:
Screen Shot 2013-04-22 at 14.53.39.jpg
And here's the xls:
magic tcg archive.xlsx