Inputting into the same access database with different file named files

[burnleypingu]

I want to create a timesheet which will have four tabs inside it with one of them being called 'data' which will be the one which will be imported into the access.

I also want to save the document file name to be saved as the information provided on the 1st tab (eg date - shift - machine - name) but I'm guessing thats more a VBA/Macro question.

The data will be information fed from the front three tabs so all the info is collated together and is clean and tidy and formatted on the 4th tab 'data'.

I then want to be able to import this data into an access database 'prod data' but this is the tricky part. I want to be able to set a macro up on the timesheet so when you press the button assigned to the macro, the following process will occur

> save the document
> import the data into the 'prod data' access database
> bring the original blank ready-to-go again timesheet up on the screen



In summary,

I'm struggling to save the document file name with info provide on front page of timesheet

How do you set it up so the sheet (under the original file name and another file name) can be inputted into the same access data base

How do you get the macro to save the document, import the data and then close that sheet and then open a new original timesheet up ready for the next person

A bit vague but hopefully somebody out there can help

I'm really struggling (but hours of research into this but can't get anywhere)

PLEASE HELP

 

[burnleypingu]

The first photo is the timesheet process

The second photo is the access process with the close down and new file bit