Consolidate list from multiple worksheets

[VT]

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