Where there is currently a button, that is where the construction details from tables 2-4 would go. for example, button 1 gets clicked. and it brings up a list of doors, wood builds, stone builds, etc. user selects a choice, then it would have the user pick a more specific choice based on the prior choice. after the selection is found, the choice populates the initial cell with the construction number,
This sounds like you are still visualizing this data entry process as something that consists of user forms and buttons and the macros that run them. It can be done, but, as I noted before, I doubt that any spreadsheet with that kind of macro controlled data input process is going to be compatible with other spreadsheets (around here, that means Excel). I can't help with that kind of input method, so others will have to help with that. Are you ready to lock yourself into Excel only for this project?