I Have opened a webpage, multiple pages by clicking add tab. Now I wants to copy paste web page to excel sheet in different column.

E.g 15 to 20 pages are opened in google chrome. Now I want to copy and paste (select all webpage(ctrl+a), copy(Ctrl+C) and in already opened excel sheet in column A paste special and then text, next xopy data in second tab, paste special text in column B. till all the data copied from already opened webtab. The number opened web tab is not specific, it may be 1 or 10 or may be 15. In short After opening all the webtab when the macro runs it should copy all date from webtab to excel sheet. Please help