Get Cell Value From Sheet In Sheet Array

JP,

Still does not work.

Probably have to give up at this point and work on Norie's code.

Norie,

It's close, take a look at the output you posted, both files show 1.1 in cell A1
The file named 1.1 should show 1.1
The file named 2.1 should show 2.1

When I ran it, I received files 1.1 and 2.2 respectively.

Thanks
w