Why do you want to copy it one cell at a time?

Worksheet1, A1 is the data input range for a dynamic web query.

What do you want to do in the source sheet if there is
not value?

There will always be a value...