In order to help you please post:
1) few lines (the common column and few others, just for a demo and testing)
2) what output (merging or concatenating sheets) do you expect :
3) what was your code, what was your output and why it did not fit your expectations.
... View more