I am trying to create a macro when run will change the information in the specified cell to a cell referenced from another work sheet below is the code when run it come up “object required” where did I go wrong? Thanks.

Range("c21") = !Loads.From.East!T5