I've been sufficiently confused by all the threads I have found on this topic so far so must now seek help.

Currently I maintain an excel workbook which I update manually each week, I get the information from an online system and have to sift through all the records for the week to pull out the relevant information. This informaiton is updated by colleagues in other areas of the organisation.

What I'm looking to do is create an access front end which colleagues can use to add the specific information that I require, this is then stored in the table. The access file will be held on a different network drive to the excel file so the link can't be automatic (and nor does it need to be) so what I need is a macro/code/link that operates when I open either file on my computer (where I have access to both drives so the data can transfer between them both).

Preferably it would just be a button on the access database which copies the information from the eight tables to the eight corresponding excel files. All the column/field headers would be identical so it simply needs to add the new data to the bottom of the excel file. It might be possible that more than one person is using the database at the same time but they won't be accessing the same table, would that be a problem?

Thanks