In worksheet A, there is a range A1: J20
in Worksheet B, there is a range A: J
Each day new content is added to Worksheet A replacing the previous one. For example this content could be A1:J4, or A1:J16. The macro should just copy the latest content, not the whole range, and past it to the last row in Worksheet B.
Day1: copy WS A, range(A1:j4) to WS B, range(A1:J4)
Day2: copy WS A, range(A1:J2) to WS B, range(A5:J7) (i.e. copy just the content and find last row and paste)
Day3. copy WS A, range(A1:J10) to WS B, range(A8:J17)
And so on......