Copying and deleting data from multiple sources.

[alzibob]

I'm trying to copy some simple data from multiple different sources on the same shared drive, put it all on one master file, and then delete the source data. The workbooks all have different names, and the data i want is on a different named tab on each WB.

This will be done everyday, and each day i want the source data deleted and added to the previous days master file.

I'm sure im over thinking it, and i've tried copying partial code from all sorts of sources, but i can get anything that works.

Can someone help a vba novice before i hang up the hat and CTRL +C, CTRL+V myslef to death.

Thanks