Return Unique Entries from Multiple Sheets into Master Sheet (in Excel 2003)

Hello,

I currently have a workbook set up which has data connections to 7 different databases. Each database (Allocation, Cell, Computer, Phone, Rent, Transpass, and Xerox) is contained on it's own separate sheet, respectively named. I also have an eighth, "Master", sheet, which I am hoping to use to aggregate the aforementioned databases in.

On each sheet, I have a column, titled "MDET", which concatenates relevant information for each entry into a "Month | Department | Employee Name | Type" format. For example "2011/12 | 201 | Smith, John | Base". This effectively creates a unique key, which I will later use to reference information from each database.

I've also set up dynamically named ranges for each table, using Insert>Name>Define, with an offset function. For example, my Allocation table is named "Allocation_Database_Table", and it "Refers to:" =OFFSET(Allocation!$A$1,0,0,COUNTA(Allocation!$A:$A),COUNTA(Allocation!$1:$1)). "MDET" for that table is contained in Column K, but "MDET" in other tables is contained in other columns.

What I'm hoping to do is to create a macro that goes through each "MDET" column, and returns only unique values to the "Master" sheet in Column A. Is this possible? It might also be easier to return ALL "MDET" entries, and then set up a macro that unique filters, but I'm worried about the unfiltered entries being >65,536.

I'm also open to non-programming solutions, however, I'm finding that some things, like PivotTables are too memory intensive and do not fit my needs exactly. Also, I don't believe I can attach my file as is as an example, because it contains sensitive information for employees.

Any and all help would be greatly appreciated!

Thanks!!

John