copy and paste data from specific cells from multiple worksheets

[JASONCAO]

Hey guys!

I have a situation that I am trying to figure out how to do it...as I never dealt with writing macro for multiple sheets before.

I have a Template Sheet and want to copy several cells (for example, cell B5 and C5) from another "Usable Data" Sheet into the Template and save it as another name. The format and layout of these two sheets are exactly the same so the cells should be copied and pasted into the exact same spot. There are over a hundred "Usable Data" Sheet and each of them has different names. It troubles me to write it in macro since there are so many different names and I didn't know how to automate it.

Thanks!

 

[JASONCAO]

up