Values from one sheet to another without blanks

[MSCF]

I have two columns on Sheet2 (C and D) that I need to be displayed on Sheet1 (starting at A6 and B6) without the blank rows. The placement of blank rows changes depending on values entered elsewhere on Sheet1, and I need the results to be updated as new information is entered. Any input on formulas that would help would be appreciated.

[Max, Singapore]

Here's a formulae construct to deliver the intents ...

In Calculations,
Put in E2: =IF(COUNTBLANK(C2:D2)=2,"",ROWS($1:1))
Copy E2 down to cover the max expected extent of data, eg down to row 200?

Then in Sheet1,
Put in A6:
=IF(ROWS($1:1)>COUNT(Calculations!$E:$E),"",INDEX(Calculations!C:C,SMALL(Calculations!$E:$E,ROWS($1:1))+1))
Copy A6 across to B6, fill down by the same extent of 200 rows, ie down to B205
That should return the desired results from "Calculations" all neatly bunched at the top w/o any blank rows
Note: The same formula in A6 above can be used in any starting cell in Sheet1
---------------------------
Success? Celebrate it, click the little star at the bottom left of my responses

[MSCF]

Here's a formulae construct to deliver the intents ...

You nailed it. Thank you.

[Max, Singapore]

welcome, glad to hear