Hi there! I'm pretty new to VBA, and I'm trying to automate our time tracking process for one of our departments as much as I can. What I'd like to do is run a command from our main payroll prep Excel file (File A, for simplicity) that will open the first person's time sheet in a given folder (File B1), and copy the necessary values into a table from a separate file (File C) that will later be uploaded into our payroll system. Then File B1 will close, and File B2 will open for the next employee's hours to be copied into File C.

Can anyone help with just the first few steps on how to get the loop started to open one file at a time and copy the values, taking into consideration that all the files will have unique names for each employee and each pay period (i.e. the file names in coding can't be static because they change each pay period).

Thanks, everyone!