I have Googled this, but Google is littered with too much crud on the subject of joining/merging worksheets.
Lets say I have three worksheets (Sheet1 and Sheet2 and Sheet3).
Sheets 1 and 2 are manually updated with data.
I want sheet 3 to automatically gather the data into itself. It doesnt have to do any error or dupe checking.
Does anyone know how? I seem to be able to do some complex things in Excel, but basic stuff breaks my brain.
I have tried the 'Consolidate function, and selected the ranges on both sheets, but just get no output at all in Sheet3 (which I am initiating the consolidation from).
Sheet1
a b c
1 bob napier
2 fred hastings
3 sally gore
Sheet2
a b c
1 mike auckland
2 joe hamiltron
3 ian opotiki
Sheet3
a b c
1 bob napier
2 fred hastings
3 sally gore
4 mike auckland
5 joe hamiltron
6 ian opotiki
(obviously the above is a tiny amount of false data)