Write Code to standardize to the current units (Brigade Level)
Import the files
Have Karen BW work with Greer on this
Get Org Reps to tell us who is in their units
Add the unit members to the units using both the master-sub relationships and by adding data to the unit of assignment field., Possibly export all of the member data into spreadsheets. Format the unit of assignment field based upon the current unit values so that the org reps can pick their people. Once we get the data back, then the records can be filtered by unit of assignment and then have the "Master Member Id" field populated by copying in the value from the unit in Yourmembership.com.
Have Greer collect unit data from Buddy D based upon the YM.COM import template.