I have a spreadsheet that will have tabs for each month. There are fomulas
in the worksheet that reference the previous months tab (that would be labled
for example March.) Is there any way that I could have a cell in the current
worksheet that you could input the previous months name and the formulas
automatically change to reference the proper worksheet with the same name?

I would ideally like to copy the worksheet change a cell for the previous
month and not have to re reference the formulas to pick up the proper tab.