Hello. I have about 900 worksheets (worksheet1, worksheet2, etc) all
of which have a single cell (mixed in with many other cells with data)
that i am interesting in copying and pasting into a single
spreadsheet. Am wondering if this is possible to pull of.

Basically, in every single worksheet, in rows 2, 3 or 4, there is a
single cell that has "PCP:" followed by the address i need.

Ideally, i can find a way to copy the contents of all of those address
cells into a single worksheet in A2, A3, A4, etc (i.e., into a single
column).

Any suggestions (including VBA code) would be greatly appreciated.