I have information which is worked out in a report and i need to be able to store this information in a table or something. I have tried to output to excel but i cant get it to work properly to name the sheets in the spreadsheet with the month it refers to and session name. Would it be possible to transfere this data to a table within access rather than exporting to excel.

Why do you need to store it if the report can be reproduced at any time?

when the month is up the report is reset so the information will be lost

Can't you use date parameters to recreate it?