View Single Post
  #1   Report Post  
VT
 
Posts: n/a
Default 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