A further question.......................
Currently, new data rows are added to tab 1 as it becomes available

For tab 1_b, I simply copy the last row down to produce the extra rows

For the b1_transpose tab, how do I accommodate new data columns from tab 1_b as the range is fixed?

Bob M