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.