i have the formula used in sheet2 to calculate unique rows and i want the result to be displayed on D10 cell in sheet 1
Just link cell D10 of Sheet1 to the relevant cell in Sheet2, i.e. if your formula is housed in cell A5 of Sheet2, you'd use this in cell D10 of Sheet1:

=Sheet2!A5

Just change the cell reference (i.e. A5) to suit.