Hi all, here is my problem and desired goal. It shouldn't be so hard but I'm not too smart with excel.

Spreadsheet A: I have a ton of raw data, so for example, Name, Number, X, Y, Z.

Spreadsheet B: I want to pull the data from spreadsheet A, into this one, ALL AT ONCE.

I know how to do it one at a time, I just click "='Spreadsheet A'$A$1"

I want to know, how to do all at once, so I can create just one row of values, and then 'drag it down' to pull data from the entire spreadsheet A and populate B.

Please let me know if this makes sense and if you have any ideas for me!

Thanks,

Mike