Copying cells macro

Closed
Report
-
Hello,
I have a number of workbooks and worksheets that i have data on but i have only two cells on theses worksheets and want to put all this data in a single sheet does anyone have a marco that would help

Thanks
David