I have a workbook with 140+ worksheets of identically formatted information. I need to consolidate certain cells from these worksheets into a summary table within a new worksheet. This would take days to do manually and leaves lots of room for mistakes. I've had no luck finding a formula or method to do this in a more efficient manner.

Can anyone help me create a macro that would automatically take the coorosponding cells from worksheets "a, b, c, d, ....." and list them on a single worksheet in a list or table format? I was thinking that a macro with some sort of loop would get me there. Has anyone had to do something similar? Any suggestions or solutions?

Thanks,
[email protected]