Worksheet function Cells applying reference sheet another
Check Details
worksheet function - Applying reference to another sheet to all cells