Copy Formula to Same Cell New Worksheet and Increment Row by 1

Hi

you could try this way

1. paste the UDF below to a standard module

Please Login or Register  to view this content.

2. then paste the function below to the sheets you want to pull a value from Sheet1

Please Login or Register  to view this content.

only to remeber, in order to paste de function you can select all the sheets at once by clicking on the tab of the first, say Sheet2, and with Shift pressed then clicking on the tab of the last one, say Sheet20, choose a cell and paste