Consolidate list from multiple worksheets
Hi All,
I have several worksheets, each of which contains identical numbers of
columns and headings. I want to consolidate all the data in columns A of
each of these worksheets into a different sheet, such that each time I make
a change in one of the sheets, the consolidated sheet updates with the new
data. Can you point me in the right direction?
Thanks,
VT
|