Hello all, I have a specific request that is a but above my abilities with Access. A little background, I am in the Navy and I run data analysis and trend analysis. I pull data from another program via an ADHOC and save it as an excel file. I then have to manually copy the data from that saved excel file to the master excel file. The master excel file is linked to my access database to give me the print out of the report and has programmed in various and/or statements to further break down the data. However, at the beginning of each month it takes me a substantial amount of time to save all the different ADHOCs then copy and paste them to their appropriate master excel file. I have no issue with this but I am trying to streamline the process to be able to share the database with other commands in the Navy for use and want to make it more user friendly. Now, what I would like to do is create a command button in Access that when clicked will extract the data from the monthly excel file and copy it to the master file. Is this possible to write VBA for this? Or am I thinking to robust for the project? Thank you for any help you can provide!