Can VBA house lookup tables

Hello, all. I'm trying to update a macro we use at work for formatting/finalizing invoices we receive from suppliers. We have a template they all submit their invoices on. We use personal macros to format the worksheet, but still have to manually populate some of the other data. This manual population of information could easily be achieved with a lookup table (entering regions, business units, etc), but without updating the template and having all our suppliers switch to the newer version, we can't do a lot with it. I'm curious if I can incorporate a lookup table into the macro itself. I'll be leaning on the wonderful users of this site to help me with the coding, but I first wanted to understand the capability. Let me know if you need any other information in order to speak on this. Thanks in advance for any clarity you can provide!

Thanks for the reply. Let me make sure I'm following.. You're saying create a workbook w/ the lookup table, distribute this workbook to the users on our end and have the macro reference the lookup workbook to find the proper values? For what it's worth, our BUs shouldn't ever change, so it shouldn't be a problem if it's difficult to update a lookup within the macro. Maybe this isn't the path of least resistance, but my original hope was to incorporate the lookup values into the code, then just distribute the code for our users to update their macros with.