Ok So I got this to work just the way I wanted it to, however..
Here is my issue. I have 2 worksheets. Worksheet 1 is a summary of the data on worksheet 2. The Macro's I have recorded are simple copy and paste functions. When the data is selected within the validation list, that data causes the corresponding macro to run. The Macro copies the specified data from sheet 2 and pastes it onto sheet 1. Works like a charm.
The problem is that for that split second when the macro runs, you can see the workbook jump from worksheet 1 to worksheet 2 when it copies and pastes the specified data.
Is there a way to do this without seeing that "worksheet jump"? It's OK if there isn't, just curious though because it's semi-annoying.