I have many titled worksheets in one workbook. I want to copy cell a10 and
cell J10 from each worksheet to a new worksheet in the same workbook so
column a lists all the cell a10 data and Column B lists all the cell J10
data. Each worksheet has its own name.
What's the easiest way to accomplish this?
Thanks.