I'd suggest that you do the following:
1) Publish your data sources and set them up on a refresh schedule. Publish a Data Source
2) Make sure your workbook is connected to the published data source (as opposed to connected to your original source). It will actually prompt you to do this when you publish the data source.
If you do the above, the data source will refresh automatically according to the schedule and the workbook will then have the most recent data.
Hi, just following up on this one. Let us know if we can be of any further assistance.