In all the examples above, if more rows or columns of data are added to any of the source ranges, VSTACK and HSTACK won't pick them up. However, if your source data is formatted as Excel tables ...