I wonder if someone can give me the best techniques to achieve the
following.

I am building my first vba / excel app and have created a worksheet
to hold variables

I have used names to identify cells.

I have called the worksheet which stores the variables wsVars
On the worksheet there will be cells like

WorksheetName (the data for this cell would be wsVars)
VatRate (the data for this cell would be 1.175)
etc

I trying to avoid globals and have the ability to change the
operation by chaning the variables

Also items like vatrate will usually never change but the ability to
have an admin screen later on to change the control variables is why
i look upon coding this way

So how do i set this in my code and how do i refer it when i then
want to access cells to put data in and out.

I orginally set up a function to get the worksheet name but thought
this was silly ... ok it works but it calls the function every
couples of code.

If people have a tutorials, links, examples or an explanation of
techniques or structured ways of carrying it out