Urgent - need help with some (simple) VBA that I haven't got a clue about!

General information for the business: spend planning tool for media
Kind of development: Customization of existing program
Num. of modules: 1
Description of every module: Not sure what a module is, but the code on my excel has stopped working and I need to fix it!
Description of requirements/functionality: Need to automate 'copy-paste' between sheets
clear original sheet.
Specific technologies required: excel
Extra notes: Seeking an expert who can ideally fix some VBA on an excel model / tool I'm helping with REMOTELY (i'm not really supposed to share the file you see). If this isn't possible, suggest a work around or I might have to share the file.

Should be a very simple job... the macro used to work and now it doesn't (!) and I can't do VBA!

NEED TO DO THIS IN THE NEXT HOUR OR TWO IF POSSIBLE - HOPEFULLY WE CAN COORDINATE!

Thanks v much,
Tom