Excel 2013 :: 3 Different Datasets - How To Sort Fields

I am currently using Excel 2013 inside of Windows 7.

I have 3 different data sets and in each data set the only unique identifier is the card number. I currently have to manually sort each of these fields because of the different variables in each data set. My overall goal is to align every user across each row so I can verify whatever status I have for the Card # in the first data set is the same across the other data sets. Is it possible this process can be automated by using a VBA macro that sorts, aligns and leaves empty spots when needed. Once again the only unique identifier that matches across all data sets is the Card #.

User Name
Card #
Status
User Name
Card #
Status
User Names
Card #
Status

John Smith
12345
Active
John Smith
12345
Valid
John J. Smith
12345
In Use

[Code] ..........