Steve, technically your code did look in the directed folder, took the information I was looking for and copied it to the Master file. However: 1) the code itself was very confusing and I wasn't sure where to interject my example files' to get it to run on the example sheet and 2) when the data was copied to the Master file, it copied over the bottom row instead of in the table.