Is there a way to pull multiple spreadsheets into one file?

You can pull entire tables to one file by referencing cells with data from other sheets. Note. This will do if you need to merge two or more sheets within one Google spreadsheet. To merge multiple Google spreadsheets into one, jump right to the next method. So, my data is scattered all over different sheets: June, July, August.
For More Information Please Refer:

You May Also Like to Read: