Multiple Worksheets To Master File

[greenlight]

Hi Everyone,

I'm trying to consolidate multiple worksheets into one master file and am having trouble with it. I'm very new to VBA so hoping for a non-VBA solution. Tried the RDBMerge add-in but the combined data set doesn't read what I'm looking for and I haven't figured out how to use the sum formula to do this. There are maybe 200 sheets that I am trying to consolidate. The data is an output from a system so it's not very organized but basically each sheet has a particular record to it with line items and dollar amounts. Would like to have it in a sortable format. Tons of spaces and merged cells in between all of the sheets. Any insight into how I can do this would be great.

Thanks.

 

[greenlight]

Created an example here to show what I am working with:

Wikisend: free file sharing service

Thanks!

 

[greenlight]

Anybody have an idea on how we can do this? Thanks!