Repeatedly reference data from a personal macro

Hi everyone!

I have a macro in the personal.xslb that I use with exported reports daily. One of the features I would like to add is something that references a table in another sheet that doesn't change of 400 or so rows and does a lookup to return a value. I could just read the table in every time I run the macro, but I just want to make sure there isn't another way of storing this data within this macro so I don't have to read from another sheet every time I run it. I'm thinking no, but just wanted to check.

Thanks for any advice!