From an original cell, I enter a value then the formula need to populate other cells , , ... The data are in the same worksheet that the displaying one. They are organized by row (each row represents a client)
You should be able to switch to another sheet and simply select the value you need by clicking on it. You should end up with a formula like this (that calculated the mean of a value from different the current sheet and another sheet called Sheet1.