Copying Cells From Multiple Worksheets to Create Summary Sheet
I have multiple worksheets that have an identical form that different people
fill out. I would like to create a summary sheet that pulls from the same
cells in each of the different worksheets. Is there to create a column on
the worksheet that increments by a worksheet as it goes down. For example
lets say I want to pull cell A20 from each worksheet i would want Sheet1 A20,
Sheet2 A20, etc going down the column. I am doing this manually which is
very tedious.
Thanks for any help,
|