Combining combo box data from different sheets in to one sheet

[rajniissh]

Hi,

I have 50 separate xls sheets from 50 users and every sheet has set of 10 combo box, i want to combine data in user sheets in to one sheet. For instance first row would have date from sheet 1 as - user 1 combo box 1 combo box 2 .... combo box 10, then second row would have data from sheet 2 as row 2 - User 2 combo box 1 combo box 2 .... combo box 10.

Could someone please help as how this could be done.

Regards
Rajnish

[JohnTopley]

Please post a sample file (not image) showing required output.

To upload file, click "Go Advanced" then scroll down to "Manage Attachments"