Excel to Access to Excel for report automation

[Nicholaspoe]

Hello everyone!



I am stumped. I want to automate my team. I send a report every few hours which has data that updates throughout the day in our company software. Currently I need to export to excel data from our software and copy the export into excel, run a macro, and resend a link to the new file template on our shared drive

What I would like to do is send one report out that will update throughout the day whenever I update my main report using tables or a data connection. To do this I am thinking I can paste the export into the macro, import the results into access, and then import directly into a template that can be updated all day long whenever I update the source. I tried going from excel to excel but you cannot share a workbook with a table.

Is this possible? Is there an easier way? Thank you in advance.