Consolidate 5 sheets into one master (Same Range and headings)

[cmorten82]

This seems like it should be pretty straight forward but every code I have tried doesn't work and it is probably partly be cause I don't understand the code. I have also tried things like power query and some other options but again nothing.

I have 5 worksheets (Current Month, 1st Qtr, 2nd Qtr, 3rd, 4th Qtr) each sheet has a range from A2:O345 they all have the same headings. I just need to put all the data from each worksheet into a master worksheet. each column is unique and some columns within that range are blank and some have formulas if that matters. The range of the data will change but it will always be equal on all sheets.

[hudson andrew]

Can you give us your Example file .

[Logit]

cmorten82:

Look here: Link

And here: Link

And maybe here: Link

Different approaches, perhaps one meets your need.

[MarvinP]

Hi,

I'd do this using Power Query if you supply a Sample workbook.
Read about it at:
http://www.excelguru.ca/blog/2014/11...g-power-query/

[cmorten82]

sorry here you go.

[cmorten82]

cmorten82:

Look here: Link

And here: Link

And maybe here: Link

Different approaches, perhaps one meets your need.

Unfortunately the second two links I tried and couldn't get to work. The first link only seems to work if all sheets in the workbook are all the same and there are other sheets in this workbook that are not so the first link won't work.

[cmorten82]

Hi,

I'd do this using Power Query if you supply a Sample workbook.
Read about it at:
http://www.excelguru.ca/blog/2014/11...g-power-query/

I was trying to get the Power Query to work but when I followed the steps in the link it pulled in all the sheets which I was able to sift through and choose only the ones I wanted but when I made any changes to the source data and then tried to refresh it wouldn't refresh. I am also trying to automate this process for a coworker who knows very little about excel so this might be a little much for them.

[Logit]

See if this works for you.

[cmorten82]

See if this works for you.

Thank you! exactly what I needed.

[Logit]

Your welcome. Glad I could help.