I want to bring all the data in different sheets(same file) in a single sheet. The data is in the same format shown below in all the sheets. [TABLE="width: 500"]
<tbody>[TR]
[TD]Description [/TD]
[TD]Drawing no.[/TD]
[TD]EDP[/TD]
[TD]Unit Price[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need to have a single sheet having the same column headings at the top of that sheet. On searching, I read something about consolidate tool, but having a little difficulty in using it. Kindly help.
<tbody>[TR]
[TD]Description [/TD]
[TD]Drawing no.[/TD]
[TD]EDP[/TD]
[TD]Unit Price[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need to have a single sheet having the same column headings at the top of that sheet. On searching, I read something about consolidate tool, but having a little difficulty in using it. Kindly help.