Copy of data automatically
 

I am wanting to look up 2 seperate spreadsheets that contain different data.
I am able to do this acroos columns but then I want to be able to
automatically pick up the data from all rows. Like dragging continual dates
or numbers but with a formula to pick up data from both spreadsheets into one
combined spreadsheet