If someone could help me with this I'd be most grateful.

I would like to have the name of a document in A1 and the number of copies
to be printed in B1.

(and so on down the column)

all documents, spreadsheets are formatted to fit on one page and they are
all in the same directory.

regards,
DL