how do i use import to consolidate data from multiple sheets

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

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" <[email protected]> wrote in message
news:[email protected]...
>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