excel macros

I am looking for someone to write necessary Excel macros to automate specific tasks. I would like the macros to be based on a sample file or template that I have, and I would like them to be activated manually. The specific tasks I need automated are editing a set of tables in individual files so that they can be consolidated/added to another table in a different (master) worksheet which then can be sorted and filtered. I am open to suggestions for any additional improvements.