'Pushing' data from 1 sheet to another
 

Is there a way to 'push' data from one sheet to another? I am thinking of
some kind of formula like an if-then-else.

I want to check a cell on sheet 1 for a certain value (such as the number 5)
and if the condition is met, then I want to copy or 'push' other cell data
from sheet 1 to other sheets in the workbook. I realize I can use the 'if'
function in a cell on the sheet where I want the data to end up which would
'pull' the data from sheet 1, but this will not work for me because I want to
use the data in the cell on sheet 1 to determine which other sheet in the
workbook the other data from sheet 1 is copied to. As an example, if the
number 5 is in a cell on sheet 1, then I want to copy or 'push' other data on
sheet 1 to sheet 5 in the workbook.

Thanks for any help,
Learner101b