Linking to future sheets/future files

[dabrot791]

To start, I'd like to say this forum is awesome and has saved me more than a few times. Thank you to all the experts!

Now, I have a bit of a problem. I have a series of report files documenting daily activity. Usually, these files are saved by month. In otherwords, a daily activity report for August. Within each file is a tab for each day. Each tab also has one cell that lists exactly that day. These files are saved on a server.

Based on these files, we must collect data and create a summary for the week. It must include total number of people from each team for the day and the weather for the day. This will be collected in a database such that for any 7 day period that we select, a summary table can display all the information we want to know. The database has been created, however, I would like to automatically link the database with the daily activity report files. Source data location will be fixed, so no need to find that, however source tab and source file will change. Since this is an ongoing report, these links must be dynamic, searching for the correct file and tab in accordance with the date required. The above is an approximation of the end product. Is what I am looking for possible? Please help!

[TABLE="width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]8/2
[/TD]
[TD]8/3
[/TD]
[TD]8/4
[/TD]
[TD]8/5
[/TD]
[TD]8/6
[/TD]
[TD]8/7
[/TD]
[/TR]
[TR]
[TD]Weather
[/TD]
[TD]Sunny
[/TD]
[TD]Cloudy
[/TD]
[TD]Snowy
[/TD]
[TD]Snowy
[/TD]
[TD]Rainy
[/TD]
[TD]Sunny
[/TD]
[/TR]
[TR]
[TD]Team A
[/TD]
[TD]25
[/TD]
[TD]24
[/TD]
[TD]17
[/TD]
[TD]15
[/TD]
[TD]19
[/TD]
[TD]22
[/TD]
[/TR]
[TR]
[TD]Team B
[/TD]
[TD]6
[/TD]
[TD]5
[/TD]
[TD]9
[/TD]
[TD]8
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[/TR]
</TBODY>[/TABLE]