Dear All,
I am trying to consolidate worksheets "Forms Analysis,G_drive,Scroll_Word,Scroll_PDF and System Issue" into "Summary" worksheet in the attached file.
But the challenge is I need to get few common cell details from Home sheet like "Employee Name, ID, TL, and area belong to (Column D3...