[CWatkinsNash]

Here's my situation:

I have been managing both my roommate's ebooks (epub) and mine (mobi). For simplicity's sake, I created an epub only library. Initially this consisted of epub versions of books that were already in the main library, but as we got more books that only he was interested in, I put those new ones in that library only.

A while back I realized I had more than a few books that needed metadata work and other fixes. Because I didn't want to deal with them at that time, I moved them into a "working library" to be fixed. Then I ended up creating yet another... Now I have 5. Yes, I know that's not generally considered best practice, but while I wouldn't recommend it to most users, it's been working really well for me...

...but recently, I realized I wasn't happy with my main library and made a lot of changes to my workflow, and now that I've got a better system in place, it occurred to me that merging these various libraries would now be feasible and not threatening to my sanity.

Taking into account that all but one of these libraries will have at least some (and in one case, many) duplicates in one or more of the other libraries, can any of you give me some ideas on how best to proceed? I'm certainly not a new user, and normally I have no problem with this stuff but my allergies are fogging my brain and I can't seem to think my way through it.

(Or maybe it's because I just installed a virtual synth app on a virtual Android tablet that lives in an Ubuntu installation that, in turn, lives on a virtual machine inside of Win7 and I think I can see Infinity from my chair. I may have used up both my geek quota and most of my critical thinking skills allotment for the week and it's only Tuesday. Help me.)