How to get multiple sheets data into one sheet

[BharathBabu]

Hello,

I have a query…

How to Copy multiple sheet data to one sheet which has different customer names that to date wise. This has having same headings for multiple sheets... (Sheets I have 5) --- Based on this I have to create a pivot chart and pivot table on daily basis…


Sheet 1 – Headings are as follows: Column A – No.; Column B - customer name (different customer name); Column c – request number; Column D – date; Column E – Silver; Column F – Gold; Column G – status (i.e., yes or no ); Column H – Type of request.

Please advise how to get all the data in to one sheet, based on this I have to work on the pivot chart and pivot table ….


I am not familiar with Macros and VBA...

 

[bobhc]

Good day BharathBabu


If all your work sheets have the same headings then it is not to difficult, it would help if you uploaded a workbook to Dropbox.

 

[BharathBabu]

How to upload th work book here

 

[sgmpatnaik]

@bharathBabu


Hi


Please look to the forum 4 Green Sticki Key rules there you will find the how to post the sample work book


Thanks


SP