hi guys,

can't for the life of me figure this out.

i need to copy entirety of column A on multiple worksheets and paste to a separate summary sheet, it'd be super awesome if the macro could create that summary sheet.

I'm unable to upload the document due to work restrictions!

any help would be much appreciated!