multiple fields on multiple sheets

[MVic12270]

Not even sure if this is possible.

I have a workbook with 31 sheet and want to st up an extra sheet that pulls all the data from A22 to h42 into a list to look like

1st A22 B22 C22 E22 F22 G22 H22
1st A23 B23 C23 E23 F23 G23 H23

and then so on that I can then drag to change the "1st" to "2nd" and then "3rd" and so on

I have so far just been using a simple ='1st'!A22 and manually changing the date when needed, which is time consuming

Any help would be very much appreciated, even if someone can tell me if its even possible or not........

 

[kvsrinivasamurthy]

Pl load some pictures of 2 sheets of 31 sheets and expected result in other sheet.

 

[MVic12270]

Pl load some pictures of 2 sheets of 31 sheets and expected result in other sheet.

I cannot post with attachments

 

[Joe4]

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.