How to transfer data from mutliple tabs to one main tab

Hello everyone,

I'm new to excel, so far I've been hacking away with Excel and been doing fine, but what I need now is a bit to complexe for me. could anyone help me please?

I have an Excel worksheet with multiple tabs (13) called:
(ABCB,ACQUISITIONS,DO,FIN_AND_ADMIN,HR,CIOB,IS,LS,PPB,PPCB,RPB,TB)
they are all different Branches at the government were I work and I also have one other tab called (Details)

Each week or so I get info from the different branches that I enter in it's respective Tab starting at range A6 to J6 and when I get new info I add it on the next available line A7 to J7 etc...

What I'm looking to do is to automate via a VB code or Macro (if possible) so that as soon as I enter one informtion in any of the branches tab, it automaticaly copies the info in my (details) tab starting at line A9 to J9 and so on.

is this possible????? Ok, I'm sure that anything is possible in Excel with the right Excel guru....but I'm far from that..

thank you so much

Brian

Actually, this was what I had in mind initially, but even by using the regular formulas, I was not able to find the right one.

Ok here is my sample workbook, were in th details tab I have my information that I'd like to transfer ''automatically'' to the associated tab whenever I input a new set of data in the details tab.

Do you see the attachment? I hope i did this ok

Hello again,

I was able to dig up this VBA code, that I think can do what i need, but I need I think it's missing something, but can't find what:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim LR As Long
LR = Range("B" & Rows.Count).End(xlUp).Row
If Target.Count > 1 Then Exit Sub
If Target.Row < 11 Then Exit Sub
If Target.Column <> 10 Then Exit Sub
If Target.Value = "Complete" Then
Target.EntireRow.Copy _
Sheets(Target.Offset(, -5).Value).Range("A" & Sheets(Target.Offset(, -5).Value).Cells(Rows.Count, 1).End(xlUp).Row + 1)
End If
With Sheets("details")
.Range ("B6:K" & LR), Header:=xlNo, Order1:=xlDescending
End With
End Sub

if someone can help me out, That would be awsome

Brian