Not knowing anymore about what you have than what you say, I would say copy
and paste if it's your intent to have all the data from all the sheets on
one sheet. If not, what do you mean by "consolidate"? HTH Otto
"Naveen" wrote in message
...
i have a a Workbook that contains multiple sheets with Diff data, but
having
the same Column & Rows. How do i consolidate all the data from these diff
sheets to make one report.

i hope my question is clear

Naveen