I have a bunch of workbooks within a folder. I need to add the contents of
cell A1 in each of the workbooks within the folder, but the names of the
files within the folder will vary. Can I write a function that will add the
contents of all files cell A1?

Much appreicated.