Norie,
My data is organized like this:
A main menu with several selection buttons that each bring up a unique UserForm.
The data entered into each user form flows into separate sheets which function as a database. This is working nicely and is adding rows and allocating data in the right place whenever data is entered into any of the the UserForms.
Other sheets function (and are formatted) as reporting tools based on the search criteria you enter into the reporting sheet and then pull data and populate the reports from the databases (sheet). This also is working fine.
Other sheets are used to enter data by the user (and are used as Lookup ranges that feed into the reports), like one for employee names and their department, another one for departments with a list of the Types of Work for that department (most have 25 or more items listed), all sorted in (Named) columns with a single header starting in A1.
None of the sheets are formatted as tables, since I'm not familiar with how VBA works with tables.
I want to turn the latter sheets, (Employee names, Department names and functions, etc.) into lookup tables that will populate the appropriate ComboBox or FileBox in the UserForm, based on the criteria selected in the previous ComboBox.
Thus, when the user adds a new employee name in the Employee sheet, or adds more work items to a department, this data will automatically become a selection choice in the ComboBox in the UserForm.

Sorry my reply got a little long winded....