Need help combining multiple different reports.
 

Hello.

I have been looking at these reports for a week now and I only get
frustrated. There are 4 quarters of information (detail and summary) each on
a different spreadsheet and data from multiple locations. The problem is that
every reports is slightly different. There is a lot of information that is
not supposed to be included, but is on the reports mixed in. The reports are
very disorganized. It looks like all the information was created manually.
Whoever created this report/template, in my opinion, was not thinking for the
end result.

I have no idea where to start. I have to have this done by Thursday and I am
assuming there are going to be late nights.

If it helps, a simple vlookup so far has not helped my problem. There are
incorrect spellings, information on one sheet might not be one the other,
etc. Simple put, a mess.

Does anyone have suggestions for where to start?

Should I just redo the entire report (which may take a very large amount of
time and might not be able to be completed before Thursday)?

I greatly appreciate any suggestions.