If by "rolling" you mean horizontally in a table this idea doesn't conform to table design. If you mean some kind of form, then maybe. Are you looking for some kind of Outlook Calendar thing but created in Access?
When working with a relational database, think tall and thin rather than short and wide. To properly implement your schema, you would have a record for each month rather than a column. To control what months are selected, you would use criteria in a query. If you want to pivot the result so it looks like a spreadsheet for reporting, you can use a crosstab query.
My timetable at work is very confusing, I have been trying to make it automated in Excel but am having no luck.
Essentially, I am at different locations depending on day of the week in relation to the month. For example, The 4th monday of every month I am at one place, the 3rd Tuesday of every month I am at another place.
The timetable we are given is set out as a 5 week month, as there can be more than 4 Tuesdays in a month etc.