Charles,
Here are the answer to your 2 questions.

1. Right now the files are not all in the same folder, but they can be if that is easiest.

2. Yes, I will want to pull figures from that day's "daily balance" sheet and have those figures put into the "long form april" and "sales sheet" files. There is a balance sheet file for every day from 21 different stores and each store has their own long form file.

Thanks!