BornFeb2 is pretty knowledgeable about excel, he is the most likely person I know of here on reddit (who also needs a job) to handle any scope of project. He is remotely located so that is a negative. There are some more skilled regulars who post, but most of them are not available.
How much data do you have to deal with? Excel is limited, you can get a sheet up to about 15 megs and it chugs to a crawl. There are ways to stash data into a sql database that allow larger amounts of data to be managed, but that is pretty much the point where a dedicated database application is required.
I don't know the timelines involved, but if it is really a crunch, backup might be advisable. Consider hiring one person to work local and another to work remote. This might be a 2 person job to start with.
These are just general purpose macros that should be solvable in about 2 hours by someone who is knowledgeable of excel object structure. If you want to get more specific about the kinds of manipulation needed for your particular task, I would need to know a bit more about the data involved. Keep in mind that the best data manipulators don't necessarily know exactly how to do a given task, but they know where to look to find ways to get the job done.
Write a macro to consolidate data from multiple sheets to a single sheet. All the data is formatted the same, it is just in separate sheets. This is a handy macro to have when there are 50 sheets with data and all of it needs to be combined. Bonus for knowing there are off-the-shelf tools that do this for you.
Write a macro to delete blank lines in a sheet. This one should be about 7 or 8 lines long so not much to do, but is useful when data needs to be consolidated.
Write a macro to take data from two columns, some of which is duplicates, and combine it into a single unique entry column.
Write a macro to import data from a file and/or website. If you have that much data to work with, you will need a way to bring it into a useful form in a workbook.