I'm trying to write a VBA that will concatenate the same cell across a whole folder of workbooks.
Each workbook in the file is the same, just a different topic. I have 15 different workbooks, for example I have Lion, Tiger, and Panther. In sheet 3 column D of each of these books I have some...