Excel VBA quick project

Hi, As part of something I am doing for work at the moment I have one main spreadsheet (payment changes [login to view URL]), which i need to update by copy and pasting from a series of spreadsheets each for a different month (starts 02-Payment changes September and goes up to 10-Payment changes [login to view URL]). Now the tricky bit is that the dates on the main sheet will constantly be changing. For example it goes from September to february now currently, but soon march will be added, and september will be removed when the total outstanding balance falls below 50,000. So how do I automate this without having to keep going into the code and changing the name of the worksheet to copy and paste from. Is there a way that I can type the worksheet name above each month and the macro will know this is the worksheet to go to in order to copy and paste the data.. I.e. the macro gets the worksheet name (where to copy the data) from the worksheet name i type in a cell. Looking for a way copy paste each month into the section without hardcoding the month name into the code. If you know of another way then need to know what you are proposing before any agreement, also needs to be completed within 48 hours.