Copy and Paste

I am a very novice Excel user. I work with a major restaurant chain. The store i work at is the gatekeeper for a ditrict. every week 8 other stores e-mail us thier p&l info in a standard excel document. I have to complie all of the info into a seperate document and e-mail to my boss. No big deal. before I could just copy and paste the info into the master for my boss. But the company updated the spreadsheet the other stores use and now when i paste the new info onto my master it only produces eros in all the cells. Now i have to manuals type in all the info which takes hours. How do i copy the info and paste it whitout also copying the formulas in the cell.