Hi all, I need a suggestion on how to create a rate for this.
in a folder every day I insert weekly worksheets named (Mon.xls, Tue.xls, Wed.xls, Thu.xsl, Sat.xls, Sun.xls) the days of the week.
Each 2-sheet file in one I have a graph named Mon Graf.. based on the day of the week and the other is called "Form Assignment".
In the Assignment form, the employee's name, his working hours, and which car is assigned to him are entered. What I would like to do is have a Report in a separate folder that summarizes all the assignments made in the files. I tried with query connectione, but the problem is that to maintain an order the weekly files when the month changes are moved to a folder with the name of the current month so at that point the query no longer works because I have to reciprocate the path.
Do you have any suggestions?

Thank you all