I am having problem constructing a statement that would copy multiple
cells from different worksheet that display a text output in one cell
of one worksheet.

For example: -

sub

if sheet 1 B3 has text "print in worksheet 5 B6"
end if
else if sheet 2 B3 has text "print in worksheet 5 B6"
end if
else if sheet 3 B3 has text "print in worksheet 5 B6"
end if
else if sheet 4 B3 has text "print in worksheet 5 B6"
end if

END