rearrange specific data on spreadsheet to match the rest of the spreadsheet. Is it possibl

I am having a hard time knowing how to explain what I need to do but here it goes...I receive a spreadsheet every week in which the data is always in a different order and varying lengths as they just copy and paste the data from different sources. I need the columns to match up so I can sort the data properly. Is there a way to rearrange the data in certain parts of the spreadsheet(never know where or how much) that follow certain conditions to match the other data? I have attached a shortened version of the file and added a sheet that will hopefully help explain what it is I need. Is this at all possible?

62920 _ WE 09-25-2014.xlsx

Looking at your data, it seems that the 1st table on each sheet is identical?

Do you get sent the tables in row 33-downwards, or is that something you are extracting? It appears that they are the same on each sheet, except the heading sequence is different?

The first sheet is a shortened version of what I get. The second sheet is what I need it to look like. Same data as the first but rearranged to match the 1st table. basically I need certain columns to match up on the different tables at least the cost center, tech number (dvok87548...), and amount.

Yes BS Singh that is correct for this shortened version of my file but I never know where the data will start. I would assume that the macro will need to somehow find the other tables and then rearrange them.

So you get a dump of all 6 tables, just like on sheet1? (longer though)

Im thinking something like this would be the basis of what you want...
=INDEX('WE 09-25-14'!$A$33:$M$39,ROW(A1),MATCH(Sheet2!A$32,'WE 09-25-14'!$A$32:$M$32,0))

Hello baby_kay_2003,

This is quite a challenge. The macro below works on the first tables below the main one. I need to work on an algorithm to for added columns when needed as evidenced in the 5th table.

Please Login or Register  to view this content.

Thanks for working on this for me! I am getting error "object variable or with block variable not set". Highlighting

Please Login or Register  to view this content.

did you try my suggestion in post #6?

FDibbins I did try but could not figure out how exactly to use it. I am very new to vba and still trying to learn. I did try to research but couldn't wrap my head around what I needed to do.

Hello baby_kay_2003,

Did you run this macro on the workbook you posted or your actual data?

Here is the workbook you posted with the macro I wrote added to it. This does work - no errors - but the last table is not aligned properly.

I was running it on my actual data. I used it on the workbook i put here and it worked no errors. /i think it has to be attached to the specific workbook not my personal.