First, Thanks for your response.
I played around with TAGS for a few days and the problem we are having is Calibre taking too long to load and running slow. Also, the thought of re-tagging all those books is a daunting task. Using the bulk look up doesn't work that well. ( Became a lot easier when I eliminated Amazon from the list!)