We met with the consultant this morning and he pretty much reinforced what I already suspected Drupal would and wouldn't do for our website. There are many advantages of using this CMS, and of course a few disadvantages. I'm going to compile a report summarizing the meeting and listing pros and cons. Then we will report to the Website Team to make a decision. All of us felt that Drupal would be a good CMS for us to use.
One interesting thing that the consultant suggested was for us to switch the web server to an Linux environment. Right now we operate in a Windows environment and while Drupal works with Microsoft, it works better with Linux. My System Administrator is actually excited to learn about Linux, so I was glad for that. If we do decide on Drupal, we will use a Linux machine.