Here is microsofts help support site that shows how to populate a listbox using multiple ranges

http://support.microsoft.com/?kbid=161534