Hey all,

I could really use some help. I need to create a formula to reference many
different external sheets at once automatically.

Column A Column B
Name1 \\Home\Folder\Name1.xls
Name2 \\Home\Folder\Name2.xls
Name3 \\Home\Folder\Name3.xls

Any help would be appreciated.