This Excel VBA Quickie shows you how to reference cells on separate worksheets and put their values onto other worksheets.
This is a reference tutorial that focuses specifically on showing you how to make cross-worksheet references in your macros. Once you learn this technique, referencing multiple worksheets in your macros will become much easier.
This is a very small tutorial that focuses on a single topic, but if you would like to learn more, just signup for the full vba course.
Follow along with the tutorial by downloading the files used in it. (Completely Free)