VBA to combine data from Column A in two sheets into Column A in third sheet

[lilvictorian]

Hello,

Looking for help and I think this will be a simple one for the forum. I have a file with multiple sheets. Sheet1 and Sheet2 include a list of IDs in Column A (among other columns which are not the same in the sheets). I'd like to consolidate only the list IDs from Sheet1 and Sheet2 (Column A in both sheets) into Sheet5 Column A so that the IDs are stacked with no spaces. All the sheets include a header row. The number of rows in each sheet will vary.

Thank you for your help!

Example:

Sheet1 Column A
Header
1
2
3
4

Sheet2 Column A
Header
8
9
10

Sheet5 Column A
Header
1
2
3
4
8
9
10

 

[smozgur]

This works perfectly. Thanks again for a solution and a speedy response. Much appreciated!

@lilvictorian - Next time, please mark the post which works perfectly. It would help future readers.

I switched this one already.